Can you execute a macro or shortcut keystroke within an "IF" function?

You can do something like:

Please Login or Register  to view this content.

Then assign this macro to a shortcut key, and/or the click/change event of the checkbox.

6String & Millz both approaches are very interesting. 6string I am pretty sure it is an ActiveX checkbox. I tried to attach a file to this reply, but couldn't figure out how to do it. 6String, you said "Then the macro can call Macro1 in one case and Macro2 in the other." How do you do this? Is it through the Properties box of the checkbox? Millz, you said "Then assign this macro to the click/change event of the checkbox." I did create this macro as macro3 but I couldn't assign it to the click/change event of the checkbox. Is this also done through the Properties box? I really appreciate you two responding so quickly. You don't know how many days I have spent trying to solve this problem. Again, thank you, Ty

If you're putting into a click/change event of the checkbox, it would be better to just look at the checkbox's value. This code should go into the worksheet's code.

Please Login or Register  to view this content.

To attach a file, click Go Advanced. Look for the paperclip icon in the rich text box editor, and click Add files.

6String, I apologize for not following Rule 3. Now I know better.

6String and Millz: I am having problems doing the combo box, I mentioned previously. Maybe, I should be using something other than a combo box?

Situation: Rows 13, 14, 15 & 16 are Hidden. The wording prior to the combo box is "Who are you financing with?" The combo box contains the following: None, ABC, XYZ, Other. If the user selects None, all rows stay hidden. If the user selects ABC, Row 13 becomes Unhidden. If the user selects XYZ, Row 14 becomes Unhidden. If the user selects Other, Rows 15 & 16 become Unhidden. By the same token, if the user accidentally selects ABC and Row 13 becomes Unhidden, then selects XYZ, Row 13 needs to be Hidden and Row 14 need to becomes Unhidden.

I don't know if this is possible with a combo box? Your assistance is really appreciated. Thank you in advance. Ty

If you are using a combo box instead, then you need to use the Change event.

As for the hiding/unhiding of rows, just make it that all rows are unhidden first, then hide the necessary rows based on selection.

Please Login or Register  to view this content.

Hello Millz, I have tried several things based on what you had provided in your last post. I will try to attach this excel file to this post. The file is a work in progress and may look confusing. Just concentrate on ComboBox2.... Or if you have any suggestions about the overall scope of the document, please don't hesitate to comment. Thank you in advance for your assistance. Ty

The attachment didn't work before. Maybe it will work now????

Millz, what am I doing wrong in attaching the file????????

Cas_Test3.xls I don't know if this worked

Tholmq, you successfully posted the same file three times in the span of a half hour. You may want to take a breath before repeating posts if you think something didn't work. Also, please note that when composing your post, there is a button beneath the edit box labeled Go Advanced. If you press that, you will then see a preview of what your post will look like, plus can continue editing in the box below. Then if you need to refresh the preview, you can press the Preview Post button now available under the edit box.

Hello 6String. Again, I apologize for making all of these newbie mistakes. I will do better. BTW, do you have any suggestions regarding my latest problem with combo boxes?? Ty

Try changing to this:

Please Login or Register  to view this content.

Hello Millz, It worked perfect!!!!!! Thank you once again!!! Ty

Hello 6String & Millz, you have saved me many, many hours in time and I am deeply grateful. Excelforum is a great website and I would like to contribute to it. But I couldn't find out how to do this. Any suggestions? Ty