Results 1 to 4 of 4

Checkbox selected make adjoining cells bold.

Threaded View

  1. #1
    Registered User
    Join Date
    04-17-2009
    Location
    Oblong, Illinois
    MS-Off Ver
    Excel 2007
    Posts
    2

    Checkbox selected make adjoining cells bold.

    I am relatively new to creating spreadsheets and using macros. I have a workbook with several sheets with varing number of checkboxes on each sheet. The checkboxes are linked to adjoining hidden cells. c-b, l-k, and u-t. What I would like to do if possible, is have is when a checkbox is selected the adjoing text will turn bold, and when checkbox either cleared, or check removed text returns to normal. The sheets will be printed and the data entered into another program. Ex: when c7 checked the adjoining cells d:7 -h:7 will turn bold. Checkboxes in column c relate to columns d:h, clolumn l = m:q and u = v:z. Which would make it easier to read when printed. On some sheets there may be only a few checked and this would make it easier to locate the data. The whole sheet needs to be printed as additional changes may be added later, but will be marked by pen. The clear button will remove all checkboxes from entire workbook and clear text fields, exhibitor name and number. Could possible use the clear button to change text back after printed, or create a print button that will print that individual sheet and change text back to normal on that sheet only. I have attached a copy of the workbook, all the tabs are not finished as will update as I get each sheet to work properly.
    Thanks for any help in advance.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1