LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Set condition of button on click

Thank you very much - that worked like a charm. I knew there was a simple
solution. :)
Robb


"NickHK" wrote:

Robb,
You've pretty much got it, in words, so in code:
Private Sub CommandButton1_Click()
CommandButton1.Enabled = False
End Sub

Private Sub CommandButton2_Click()
CommandButton1.Enabled = True
End Sub

NickHK

"Robb Quirk" wrote in message
...
Does anyone know how to use code or some other method to set the active

state
of a button once you click it? What I would like to happen is for Button1

to
be able to be clicked once, and then turn inactive (gray) until Button2 is
clicked. Any help would be appreciated.
Thanks in advance,
Robb




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Create floating button based on button click in menu ExcelMonkey Excel Programming 2 October 12th 05 06:43 PM
On Button Click(Help!) jpizzle[_2_] Excel Programming 1 June 3rd 05 11:32 AM
How to add a command button and on-click within vba Papa Jonah Excel Programming 9 December 2nd 04 12:10 AM
VBA button click need help. Need LEN help. Nigel Cummins Excel Programming 4 July 11th 03 08:52 PM
VBA button click need help. Need LEN help. Nigel Cummins Excel Programming 0 July 11th 03 09:53 AM


All times are GMT +1. The time now is 09:43 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"