Ok, I created a user form [frmNumberID] with one ComboBox [cboNumberID].
That's it.
Here is the relevant form code:
Private Sub UserForm_Click()
cboNumberID.Enabled = True
End Sub
Private Sub cboShowID_DropButtonClick()
ActiveCell.Value = Me.cboNumberID.Value
End Sub
Here is the code in the procedure that calls it:
*** navigation to a particular cell, then....
frmNumberID.Show
ActiveCell.Value = cboNumberID
...But although it drops the correct value into the cell, when I click the
form's close box it goes to an error.
Debug says it's this line: ActiveCell.Value = Me.cboNumberID.Value
What am I missing??
Thanx,
- Mike
Dave Peterson said:
Nope.
But you could create your own userform that does exactly what you want.
If you want to design your own userform:
Debra Dalgleish shares some tips:
http://contextures.com/xlUserForm01.html
Is there any way an InputBox can provide a drop-down list [ie Data
Validation] ?
A range named NumberID [up to six, or possibly a few more rows] should
ideally "drop down" when the InputBox is called.
Thanx,
- Mike