UserForm Combo Box Value Input
Posted by Ken on December 18, 2001 11:05 AM
I have a UserForm with a Combo Box that has a list. I would like to have this UserForm input the value selected on the list, If the active cell is in Column A and place the value where ever the active cell is in column A.
Much appreciated
Ken
Posted by Juan Pablo G. on December 18, 2001 12:10 PM
Do you want the value selected in the ComboBox1 to be in the ActiveCell of column A if the activecell is in Column A ?
How about this
If ActiveCell.Column = 1 then ActiveCell = ComboBox1
Juan Pablo G.
Posted by Ken on December 18, 2001 1:09 PM
Thanks Juan Pablo "You're the Man!"
