Macro Help (IF A1 = Yes goto cell b100...)

**nono5551212** · 01-19-2010, 05:03 PM

I want to write a simple macro that does the following.

If cell A1 = YES goto cell A1000
If cell A1 = NO goto cell B1000
If cell A1 = MAYBE goto cell C1000

I will have the 3 options available via a combobox

Thanks for helping.....

**protonLeah** · 01-19-2010, 05:19 PM

Please Login or Register  to view this content.

**DonkeyOte** · 01-19-2010, 05:20 PM

Your post does not comply with Rule 8 of our Forum RULES.
Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere.
We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.
Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!

**nono5551212** · 01-19-2010, 06:09 PM

Got the answer from another site... This seemed to work....

I created a combo box that drops down a selection... and used the below code.....

Please Login or Register  to view this content.

The 1-15 tags can be labled any way you wish via your combobox defined list.....
When selected it will add a 1-15 into a cell of your choosing....

**DonkeyOte** · 01-19-2010, 06:16 PM

Originally Posted by non5555121

Got the answer from another site...,

Thank you for posting your resolution (this will benefit others) but note that this is the entire point behind posting links to threads you've created on other boards.

People both here & there (MrExcel.com) post in their free time and at no cost.
Please take this fact into consideration and do not abuse their kindness by having them work on something unaware that it might already have been resolved elsewhere.

On a final note please endeavour to use CODE tags around your VBA... as this is your first visit I have done this for you.

Should you post on this board in future (we hope you do) please ensure you take the time to familiarise yourself with the Rules of the Forum before posting again.

**lesoies** · 02-17-2013, 10:30 PM

Hi, can anyone create a sample Excel with this combo box? I'd like to create something similar and am not sure how to do it. I've searched and could not find out how to do it.