| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Enabling a button based on Cell entry
Hi,
I have the following code: If (Worksheets("Reach Enterprise Representative").Range("A4").Value = "") Then FrmPriv.Show This is allocated to a button that opens a userform when cell A4 is blank. However, I have a second button that I want to disable UNLESS cell A4 contains data. How can I do this? Cheers J |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Enabling a button based on Cell entry
Generically:
If v="" then button1.hide button2.show else button1.show button2.hide endif -- Gary''s Student gsnu200705 "rowlo-efc" wrote: Hi, I have the following code: If (Worksheets("Reach Enterprise Representative").Range("A4").Value = "") Then FrmPriv.Show This is allocated to a button that opens a userform when cell A4 is blank. However, I have a second button that I want to disable UNLESS cell A4 contains data. How can I do this? Cheers J |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| restricting entry into a cell based on entry to a previous cell | New Users to Excel | |||
| Enabling voting button | Excel Discussion (Misc queries) | |||
| Changing Command Button Based on Data Entry | Excel Programming | |||
| Conditional Button Enabling based on Checkbox | Excel Programming | |||
| Button Enabling based on check in checkbox | Excel Programming | |||
Linear Mode
