bluegt

I am wondering if anyone would be able to help me use VB to create a toolbar in Excel that will contain a number of buttons. These buttons will pop open an interface that will accept parameters (values that will be inputted to cell references) from the user. These values will be updated in the Excel spreadheet once 'ok' is clicked. I would use and name the various dialogue boxes based on the spreadsheet calculations I'm performing. I would like to keep it simple because my goal is to simply learn how to create a simple user interface for inputting parameters and to view the resulting spreadsheet calculations in the dialogue box so the user does not have to refer to the spreadheet (except for auditing purposes.

Cheers,

bluegt

rick_deacha

Hi bluegt have you read Excel FAQ - Excel 101

In the additional resources there is a very good tutorial about userforms... I suggest you to read it, and when you have some code (and still have troubles) post your questions