Hi, Im only a beginner myself but I think you would first set focus to the text box when the form opened and then disable all the option buttons until text was entered into the textbox. You would have to apply this to the change (or afterupdate) event on the textbox as well in case user blanked out the textbox info after previouly typing something in.
example
Private Sub UserForm_Activate()
TextBox1.setfocus
option1.enabled = false
option2.enabled = false
end sub
Private Sub TextBox1_AfterUpdate()
if TextBox1.value = ""
msgbox "You must enter a value in the textbox"
option1.enabled = false
option2.enabled = false
else
option1.enabled = true
option2.enabled = true
end if
end sub
Private Sub TextBox1_Change()
if TextBox1.value = ""
msgbox "You must enter a value in the textbox"
option1.enabled = false
option2.enabled = false
else
option1.enabled = true
option2.enabled = true
end if
end sub
_________________
cheers
Parry
This message was edited by parry on 2002-10-07 21:40
This message was edited by parry on 2002-10-07 21:41
This message was edited by parry on 2002-10-07 22:58