mistydhudson Posted December 10, 2007 Report Share Posted December 10, 2007 Hello, all! I'm certain this is an easy fix, and that I'm missing something very obvious. What I'm trying to accomplish is this: When in Excel, I use the hotkey to start the macro. A multiple choice menu pops up, I choose any combination of 9 items When I have clicked the button, it inputs the text (in this case, a specific number) When I have not clicked the button, it inputs the number 0. For some reason, all I'm getting is 0s in my cells. Here's an example of what I have: Quote Link to comment Share on other sites More sharing options...
kevin Posted December 11, 2007 Report Share Posted December 11, 2007 You have the 'Checkbox Menu (Multiple Choice)' option selected. If you choose more than one item then this line (and the ones similar to it) will always be false If Variable %T1%="A" To fix this problem change these to If Variable %T1% contains "A" Quote Link to comment Share on other sites More sharing options...
mistydhudson Posted December 11, 2007 Author Report Share Posted December 11, 2007 You have the 'Checkbox Menu (Multiple Choice)' option selected. If you choose more than one item then this line (and the ones similar to it) will always be falseIf Variable %T1%="A" To fix this problem change these to If Variable %T1% contains "A" Thank you so much! You just saved me hours of work! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.