andremayer
Board Regular
- Joined
- Oct 9, 2008
- Messages
- 60
Does anyone know how to have a drop down list from an input box?
Basically, I have this:
Reply = InputBox(Prompt:="Enter TIME OF ORDER PLEASE (HH:MM)", _
Title:="HH:MM", Default:="HH:MM")
If Reply = vbNullString Then
Else
ActiveSheet.Range("d4").Value = Reply
End If
What this does is that the person using it has to properly put in the time. But, what I want to have is a drop down list when this box opens up that someone can choose the time. (15 minute interval) rather than entering it manually. So that there's no errors on the time etc.
Can someone help me with that please?
Basically, I have this:
Reply = InputBox(Prompt:="Enter TIME OF ORDER PLEASE (HH:MM)", _
Title:="HH:MM", Default:="HH:MM")
If Reply = vbNullString Then
Else
ActiveSheet.Range("d4").Value = Reply
End If
What this does is that the person using it has to properly put in the time. But, what I want to have is a drop down list when this box opens up that someone can choose the time. (15 minute interval) rather than entering it manually. So that there's no errors on the time etc.
Can someone help me with that please?
