Accessing DropDown box from a Userform

G

Guest

I have a combo box on a user form and when the user changes the value in the
combo box, I want to change input range in a dropdown box on a worksheet.

My combo is cboGrade on userform frmInput and my dropdown is DropDown5 (I
can't work out how to change its name) on sheet "Calculations"

Currently the input range of DropDown5 is Constants!$A$1:$A$50
Any ideas please?
Regards
Stephen
 
S

Shailesh Shah

Hi Stephen,

Try this for changing input range in a dropdown box on a worksheet.

Sheets("Calculations").Shapes("Dropdown5").Select
Selection.ListFillRange = $B$1:$B$50 'Change to suite

To change the name of dropdown first select it & Click in the Name Box.

Regards,
Shah Shailesh
http://members.lycos.co.uk/shahweb/
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ComboBox Dropdown not under control 1
How to Activate and Dropdown a Combo Box 4
populate dropdown/combobox on userform with specific values from s 3
Userform Combo box to mimick Worksheet Cell validation list range. 2
DropDown Change Event & Macro 2
Properties of Combo Box in Userform 3
ignore blanks in dropdown 3
How to change the font used by dropdown list box? 1

Top