Click a button - pass some information - How To?

**Askjerry** · 01-23-2014, 05:24 PM

This should be simple... but I'm missing something.

Imagine two buttons on a form.

When you click either button you want the same MACRO to run, but do slightly different tasks. (Different range, different color, etc.)
You install a variable called "mydata" and if it has a value of "1" it will behave one way, if "2" it will behave another.

For now... let's just put this value into cell "B3"... just so I can see that the data is actually passed.

Please Login or Register  to view this content.

I thought that I could just change the routine to

Please Login or Register  to view this content.

But if I do... when I try to assign it to a button...

BUTTON 1 would call DO_SOMETHING_ELSE("1")
...OR...
BUTTON 2 would call DO_SOMETHING_ELSE("2")

It say's it's too complex.

I can call WORKBOOK!DO_SOMETHING just fine... but if I add the data field... FAIL.

WORKBOOK!DO_SOMETHING("1") for example... FAIL.

So...

How do I call DO_SOMETHING and pass the variable... or call DO_SOMETHING_ELSE(data) ?

So... if the user clicks BUTTON 1, the cell B3 will display "1"... if they click BUTTON 2, the cell should display "2".

Can you help me?

Thanks,
Jerry

**mortphil** · 01-23-2014, 05:34 PM

in the button code )use an active X button, put first a boolean like dim Isthisbutton1 as boolean, when you click on the button 1 it turns it to true and then call the sub in the other module. In that sub you specify the value that your variable should have if button 1 was clicked and else what value the variable should have if button 2 was clicked.

Could you upload a sample of what you are trying to achieve, it may be easier to help you (make sure it's a XLSM)
[Phil

**6StringJazzer** · 01-23-2014, 05:40 PM

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

http://www.excelforum.com/excel-prog...on-how-to.html

Thread Closed.