Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Apr 2004
    Location
    Jacksonville, Florida, USA
    Posts
    117
    Thanks
    0
    Thanked 0 Times in 0 Posts
    My program pulls in data from another spreadsheet in the workbook_open module, using constant cstrDatabaseWB and variable strFilename. I need to put radio buttons on the opening page to allow the user to pull FY10 or FY11 data. The constant and variable are used throughout the program. Can I have the constant and variable refer to two separate paths if I put it in an IF THEN statement? It doesn't sound. Right, but I'm not sure how to do It. Thanks in advance.

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    You can use a variable in an If ..Then since it's variable, but not a constant - it has one value defined at design time.
    Regards,
    Rory

    Microsoft MVP - Excel

Posting Permissions

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