Question Locked

Control box

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have a control box that when I enter a number it fills in the sheet. The problem I'm having is that when I click on the arrow on the control box nothing is their I have to physically type in the number I can't choose the number from a list. How do I get a drop down list in the control box.

3 replies

by bg7455

I have a control box in VB everything is in place but when I open the spreadsheet I have to press Alt F11 put my cursor next to the END SUB in the first line of commands then press F5 then press Alt F11 again, to enable this spreadsheet to work. Why?

by jerry~beans&bytes

just a thought, END SUB is usually at the end of the subroutine. are you sure your syntax is correct?

This discussion is closed to new replies.