View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Toggle Button help

I put two toggle buttons from the Control toolbox toolbar on a worksheet.

I put this in that worksheet's code module:


jonco wrote:

I want to create 2 toggle buttons.

1.) Toggle button 1: When it is clicked cell C33 contains an "X" in it.
When it is clicked again the "X" goes away and the cell is empty.

2.) Toggle button 2: I want this toggle button to clear out certain cells
(a range) and when it is clicked again to put sample data in that range.

Sounds simple...but I'm having trouble figuring out how to do it.

Thanks for your help!

Jonco


--

Dave Peterson