| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
change control properties according to a cell value
Using Excel 2003 I want to make a button control visible/invisible according
to the value in a cell which contains the formula counta(a1:a10). How can I do this? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
change control properties according to a cell value
I've worked it out now. I used the worksheet recalculate event to trigger a
macro "Billums" wrote: Using Excel 2003 I want to make a button control visible/invisible according to the value in a cell which contains the formula counta(a1:a10). How can I do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I change a cell and cause an automatic change in other cells | Excel Worksheet Functions | |||
| How do I change a cell range with a reference cell? | Excel Discussion (Misc queries) | |||
| Why does Custom Format not control Cell Display? | Excel Discussion (Misc queries) | |||
| SQL - Auto Refresh Upon Cell Value Change | Excel Worksheet Functions | |||
| Look for change next blank cell in Range | Excel Worksheet Functions | |||
Linear Mode
