Thread: change control properties according to a cell value
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Billums
 
Posts: n/a
Default 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 With QuoteReply With Quote