Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Useform ComboBox to Worksheet
Ryan,
Try something like Private Sub ComboBox1_Change() Range("B2").Value = Me.ComboBox1.Value End Sub -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Ryan" wrote in message ... I have a Userform with a ComboBox on it. I want to be able to have a cell on the Worksheet be populated by the selection that is made in the Useform ComboBox. For instance, in ComboBox1 on Userfom1 "Title" is selected. When this happens, I want the contents of cell B2 on Sheet1 to say "Title". I know there has to be a way to do this...I just don't know the way... Ryan |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Useform ComboBox to Worksheet
Chip
That did the trick! Thank you very muc Ryan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
useform label enter | Excel Discussion (Misc queries) | |||
how to display a graph on the useform thru excel vba ? | Charts and Charting in Excel | |||
Listbox on a useform | Excel Discussion (Misc queries) | |||
useform autosize to fullscreen problem | Excel Worksheet Functions | |||
Copying Worksheet triggers Click event of combobox on another worksheet | Excel Programming |