View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default multipage userform question

I used the 3rd page as my data entry page:

Option Explicit
Private Sub MultiPage1_Change()
Me.CommandButton1.Enabled = Not CBool(Me.MultiPage1.Value = 2)
Me.CommandButton2.Enabled = Not CBool(Me.MultiPage1.Value = 2)
End Sub



JT wrote:

I have a multipage userform. One of the pages will be used for data entry.

On the main part of the form, I have 2 buttons (Enter & Quit). I would like
to disable thees buttons when I'm on the data entry page but am having
trouble getting started. Any help would be appreciated. Thanks.
--
JT


--

Dave Peterson