inserting check boxes from a macro

  • Thread starter Thread starter morry
  • Start date Start date
M

morry

I need to mark certain random rows on my spreadsheet to show that the
are important and that they need to look at another page to get mor
information about it.

Is there a way to insert a check box onto an excel spreadsheet by usin
code in my macro. What I want to happen is when they click on
control button a check box will appear in a column in the row that i
important.

Is this possible?

Thank you
Morr
 
Turn on the macro recorder and place a checkbox on the worksheet. Turn off
the macro recorder. That will give you the code for placing a checkbox on
the worksheet. You can add that to the code for your control button with
appropriate modifications.
 
Morry,

This is not exacftly what you want, but I have posted a previous solution
that puts a tick in a cell. It is worksheet change event driven, but you
could adapt it to you 'important' criteria http://tinyurl.com/sbur

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top