![]() |
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 |
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 |
All times are GMT +1. The time now is 03:03 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com