Accessing DropDown box from a Userform
 

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

Accessing DropDown box from a Userform
 

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/


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!