| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
multipage userform question
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multipage on a userform | Excel Programming | |||
| Multipage Userform Events | Excel Programming | |||
| Userform, multipage, select a tab | Excel Programming | |||
| Problems with the userform multipage | Excel Programming | |||
| MultiPage UserForm | Excel Programming | |||
Linear Mode
