Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am trying to create a form in Excel for vehicle requests. What I want to happen is to create one worksheet that is a recreation of the current paper form, but have a clickable button that will enter all the data for the vehicle request as a record on a second worksheet. Conversely, if you know the record number, I want the form to auto-flll the information from that record number. I have the second part figured out, that should be a simple HLOOKUP, but I don't know how to generate the clickable button. Will I need to use scripting for this, or is there an pre-built way of doing this? (As an aside, I know there are other and better ways of accomplishing database work, but the nature of my work makes Excel the best choice)

share|improve this question
Access might be better for this – Sam Jan 6 '13 at 6:37
How much VBa do you know? I am certain you will need scripting as this is a very bespoke request. – Dave Jan 6 '13 at 7:03
I don't know VBA, but I'm sure I could figure it out. Before I started scripting, I wanted to make sure there wasn't a more obvious solution. And yes, Access (or really any database) would be better suited to this, but everybody at my work has Excel and if they needed to could continue to manually manipulate a spreadsheet. We're talking a place that is still pretty low tech and lives off the three big Microsoft Office products. – eightbitdino Jan 6 '13 at 13:46
@HoldenFenner I'm just wondering if my answer was of any use. – Nick Perkins Jan 11 '13 at 1:26
@NickPerkins Does not look like an answer to me. Looks like guidance – Prasanna May 13 '15 at 7:56

To do it exactly how you want to do it, you would need to use VBA. If you want to go down a simpler path and use an inbuilt feature of Excel, consider using and Excel form.

Excel can create a fill in form for a table of data. In Excel 2007 and 2010 (and presumably 2011 - I don't have a mac to check) the feature doesn't appear in the ribbon menu by default so you have to customise it. I found some information on this over at

In Excel 2003, you can simply select your data table, go to the Tools menu and select "Form".

You could then create a command button to run a small macro to load this form each time it is required for data entry.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .