MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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!"