Thread: Userform: Enter combobox value unless textbox contains data
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default Userform: Enter combobox value unless textbox contains data
With userform1.Combobox1
.Style = fmStyleDropDownCombo
.MatchRequired = False
.Value = "Specify Other"
End With

--
Regards,
Tom Ogilvy


"smplogc" wrote in
message ...

Hi again. This forum has been invaluable.

I'd like to know the piece of code for a userform that would enter the
combobox value by default unless any data is present in a textbox (as a
"specify other" choice not present in the combobox).
Thanks!!!!


--
smplogc
------------------------------------------------------------------------
smplogc's Profile:
http://www.excelforum.com/member.php...o&userid=33887
View this thread: http://www.excelforum.com/showthread...hreadid=537875



Reply With QuoteReply With Quote