Results 1 to 2 of 2

Thread: Easy Macro Question

  1. Jul 31st, 2002, 07:33 AM #1
    Cole Patzman
    Cole Patzman is offline

    Thread Starter
    Lively Member
    Join Date
    Dec 2001
    Location
    Melbourne, Florida
    Posts
    65

    Wink Easy Macro Question

    How to reference a CheckBox on another worksheet.
    If I have two worksheets, named Sheet1 and Sheet2 and a checkbox, (chk1) on sheet1, how do I check the value of chk1.value, while working on sheet2?
    Reply With Quote Reply With Quote
  2. Jul 31st, 2002, 07:42 AM #2
    SeaHag
    SeaHag is offline
    Fanatic Member SeaHag's Avatar
    Join Date
    Jul 2001
    Location
    Lake Huron
    Posts
    901
    debug.print Worksheets(2).chk1.value

    or


    debug.print Worksheets("sheet2").chk1.value

    Seahag
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width