Macro Buttons

[mcclanat]

Attachment 20693Hello,

I would like create a spreadsheet where I can click a button called "Choose Rm Type" on one sheet, which will take me to another sheet called "Room Type List", where I could then select a button from a list next to the room type that I choose and the corrisponding information from that list would atomatically be entered into the appropriate cells in the first sheet, and the final view would also be the first sheet.

I have attached an example spreadsheet that will clarify the expanation above. I would really appreciate it if someone would show me how to do this.

Thank you!

[Leith Ross]

Hello mcclanat,

You don't need to use VBA macros for this. It can be done simply using Data Validation, Named Ranges, and a worksheet formulas. I have done this to the attached workbook. Simply click on the the Room Type and drop list will present the choices. In the adjacent cell to the right, a formula does a look up to find the square footage associated with the room choice.

Sincerely,
Leith Ross

[rylo]

Hi

Why don't you just use an incell data validation selection list? Much less complicated.


rylo

[mcclanat]

Thank you. I know I could use data validation for this spreadsheet, but I need the buttons and macros in a much larger and more complex spreadsheet where it would make sense. The large spreadsheet contains sensitive information that I can't put out for the public to view, so I just made a simple small example speadsheet to show the concept.

Would somebody please show me how to create the macros I need to attach to the buttons in order to make my example spreadsheet work?

Thank you

[westonkw]

The easiest way for you to do this is to make your macro using the macro recorder. Turn the macro recorder on, name the macro, do the steps that you want performed and turn the recorder off.