Help for Beginner - Macro with IF Statements

Hello,

I would like some help in creating a macro. My spreadsheet has four cells in which numbers can be entered: B6, B8, B10, or B12. Not all of the cells require a number. I have created an Excel formula with multiple IF statements. The formula picks up the numbers entered in the cells and puts them in another cell, B27. The number in B27 will either be from one of the aforementioned cells or a combination of two of the cells. I would like to create a macro for a button so that when the user clicks on the button the numbers either appear in B27 or, if the number is too long (i.e., exceeds 30 characters) a message box will appear telling the user that the numbers entered need to be changed. The Excel formula I would like to convert to VBA is below. It has the limit of 7 IF statements that Excel allows, but I would like the macro to include the 8 IF statements below. If am very, very green to VBA programming and do not know where to begin with this and would appreciate any help anyone can give. Thank you.

Please Login or Register  to view this content.

Thank you for responding, and I apologize. I see how this was not the best way to provide the information. Does the following make better sense?

• If a number is only in cells B6, B8, or B12, that number alone should appear in cell B27.
• If numbers are in B8 and B10, both numbers should appear in B27 separated by a forward slash (i.e., B8/B10).
• If a number is in B10, it is expected that a number should also be entered in either B6 or B8. Therefore, if a number is in B10 but not in B6 or B8, the user is notified when they click on the message button. The message would be "You have entered only an Order number. Please enter either an appropriate Schedule No., GWAC No., IDIQ No., or BPA No, or make any other necessary corrections."
• If a number is entered in all cells (B6, B8, B10, or B12), then button message will say, "You have entered too many numbers. Please delete the extraneous numbers."
• If the number that shows up in B27 exceeds 30 characters, button message will say, "The contract number exceeds 30 characters. Please shorten the number by entering it directly in B27."