ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   ComoBox Resluts (https://www.excelbanter.com/excel-programming/272532-comobox-resluts.html)

Hans Dummer

ComoBox Resluts
 
I have created a Form with a combo box drop down
selection with a list of names in the drop down and the
form also contains a command button whcih I have
called "OK".

How do I return the Name selected from the drop down to a
designated cell once the user clicks OK?


Mike[_31_]

ComoBox Resluts
 
Sheets("Sheet1").Range("A1").Value = _
UserForm1.ComboBox1.Value

-----Original Message-----
I have created a Form with a combo box drop down
selection with a list of names in the drop down and the
form also contains a command button whcih I have
called "OK".

How do I return the Name selected from the drop down to a
designated cell once the user clicks OK?

.


Nick

ComoBox Resluts
 
Use the form toolbar to create the drop down boxes.
Then right click on the drop box and select format
control, and choose the control tab
link the control to the cell immediately behind it.
Then quickly write a macro that copies the value of the
cell to the other displaying the value and you are
finished.

You may need to create a list of names somewhere so that
control can access them. The linking can also be done from
the control tab.

Nick


-----Original Message-----
I have created a Form with a combo box drop down
selection with a list of names in the drop down and the
form also contains a command button whcih I have
called "OK".

How do I return the Name selected from the drop down to a
designated cell once the user clicks OK?

.



All times are GMT +1. The time now is 08:20 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com