-
Nov 6th, 2013, 12:55 PM
#1
Thread Starter
Registered User
btnAddFacility in VBA
Hi,
i want enable btnAddFacility button after locking my excel using commandButton....
btnAddFacility should be enabled only after clicking the commandButton...
give me ur suggestions plz
-
Nov 6th, 2013, 04:36 PM
#2
Re: btnAddFacility in VBA
Put the relevant code in the Click event of the command button.
-
Nov 7th, 2013, 03:10 AM
#3
Re: btnAddFacility in VBA
Welcome to the forums sony123
Are you doing this in VBA or VB6?
A good exercise for the Heart is to bend down and help another up...
Please Mark your Thread "Resolved", if the query is solved
MyGear:
★ CPU ★ Ryzen 5 5800X
★ GPU ★ NVIDIA GeForce RTX 3080 TI Founder Edition
★ RAM ★ G. Skill Trident Z RGB 32GB 3600MHz
★ MB ★ ASUS TUF GAMING X570 (WI-FI) ATX Gaming
★ Storage ★ SSD SB-ROCKET-1TB + SEAGATE 2TB Barracuda IHD
★ Cooling ★ NOCTUA NH-D15 CHROMAX BLACK 140mm + 10 of Noctua NF-F12 PWM
★ PSU ★ ANTEC HCG-1000-EXTREME 1000 Watt 80 Plus Gold Fully Modular PSU
★ Case ★ LIAN LI PC-O11 DYNAMIC XL ROG (BLACK) (G99.O11DXL-X)
★ Monitor ★ LG Ultragear 27" 240Hz Gaming Monitor
★ Keyboard ★ TVS Electronics Gold Keyboard
★ Mouse ★ Logitech G502 Hero
-
Nov 8th, 2013, 11:30 AM
#4
Thread Starter
Registered User
Re: btnAddFacility in VBA
-
Nov 8th, 2013, 11:37 AM
#5
Re: btnAddFacility in VBA
Originally Posted by sony123
Vba only.
With that being the case, your question would be better served in the Office Development section and that is why I have moved it here.
-
Nov 8th, 2013, 05:26 PM
#6
Addicted Member
Re: btnAddFacility in VBA
Firts disable btnAddFacility button, via properties menu, after that...
Code:
Private Sub CommandButton1_Click()
' your code here
btnAddFacility.Enabled = True
End Sub
If you want disable it again, add the accurate code on btnAddFacility_click() event.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|