I'm trying write some macro's in Excel 2003 and I'm stumped.
I have a Slide Bar Shape from the Form Menu. When the slide bar moves, Cell C3 changes, and cells (D2, D3, and D4) change as a result of a formula that looks at C3. I have "Scroll Bar 1" assigned to macro "Sub ChBtn()" so that the caption text on the 3 buttons change based on the associated cell value in D2, D3, and D4.
I'm using the below to change the button text, but it leaves the last button selected and looks goofy. I was hoping to use a "...with..." statement but can't seem to get that right.
What I want to do, is have the buttons execute a macro to navigate to a different sheet, but the sheet it navigates to depends on the cell value in D2, D3 and D4 that the buttons and scroll bar are onPlease Login or Register to view this content.
My problem is this:
1. While the macro that changes the button name works, it looks sloppy. I thought I could use a "...with..." but could never figure it out.
2. I'm trying to figure out how to pass the variable used with the "button name change" (Sub ChBtn()) to the macro that the button executes when it's clicked
I've attached the spreadsheet for further clarification below.
Please Login or Register to view this content.
Bookmarks