Thread: Would like to getback a MsgBox on error
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
KBrenner KBrenner is offline
external usenet poster
  
Posts: 7
Default Would like to getback a MsgBox on error
DaveExel,
When I click on CommandButton the form appears, then I select from the list
with the key board. and then click Ok or Alt+O. I really like this better
becouse I can scroll very fast though a list of 200 to 500 values by
MatchEntryFirstLetter.

Private Sub CommandButton_Click()
UserForm1.Show
End Sub

Thanks
KBrenner


"davesexcel" wrote:


What is the event you are using to show the UserForm ?


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=535158


Reply With QuoteReply With Quote