Is it possible to make a simple interface for an excel worksheet!?

[elmoh3n]

Hi guys! I've developed two excel workbook recently, one of those is an excel-vba and the other on is a linked simple workbook which contains the excel-vba's required data. My excel-vba workbook contains a command button in its first worksheet and some calculation steps including equations written in excel cells and in its' vba code too. The resulting data will be shown in the last worksheet when the button clicked. As the excel spreadsheet is a messy user interface for some people , I'm eager for converting that to a more simple UI . Can any body help me about this? Thanks in advance.

 

[Teeroy]

Try a UserForm. See http://www.contextures.com/xlUserForm01.html for a primer and to see how they can help you.

If you need a more advanced interface than a userform there are methods to lock down a sheet and change its appearance to create a neat user interface.