Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
inserting check boxes from a macro
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 -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
inserting check boxes from a macro
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. -- Regards, Tom Ogilvy "morry " wrote in message ... I need to mark certain random rows on my spreadsheet to show that they are important and that they need to look at another page to get more information about it. Is there a way to insert a check box onto an excel spreadsheet by using code in my macro. What I want to happen is when they click on a control button a check box will appear in a column in the row that is important. Is this possible? Thank you Morry --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
inserting check boxes from a macro
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) "morry " wrote in message ... I need to mark certain random rows on my spreadsheet to show that they are important and that they need to look at another page to get more information about it. Is there a way to insert a check box onto an excel spreadsheet by using code in my macro. What I want to happen is when they click on a control button a check box will appear in a column in the row that is important. Is this possible? Thank you Morry --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Clearing All check boxes using Macro | Excel Discussion (Misc queries) | |||
Can one macro serve several check boxes? | Charts and Charting in Excel | |||
Inserting check boxes | Excel Discussion (Misc queries) | |||
Inserting check boxes | Excel Discussion (Misc queries) | |||
Inserting check boxes | Excel Worksheet Functions |