Hi there. does anyone know how if there is an excel addin that allows me to create an input form in excel. Im new to excel coding and need to build a form asap.

Many thanks in advance

Don't know if this is what you are looking for, but...This was developed a few years back for a company I worked for which is no longer in business. It uses a form for input of data in Excel. It also does searches. Hopefully someone out there can use this.

This will not build you a form but it gives you one to use.

Place your mouse inside your data.

Select on the menu:

Data / Form

Enjoy
Rob

Not sure if this has been solved for you yet but I use a form builder that you access from the VB Editor. If you go to Tools>Macros>Visual Basic Editor and open this, then click Insert>User Form. This creates a form which will allow you to interact with your worksheets using VBA. I have found it good for inputing data.
Craig

Rickster, I am looking at your excel code and don't understand something.
How is your range always equal to b1?

tbAddress.Text = ActiveCell.FormulaR1C1
ActiveCell.Offset(0, 0).Range("b1").Select
tbCity.Text = ActiveCell.FormulaR1C1
ActiveCell.Offset(0, 0).Range("b1").Select
cmbState.Value = ActiveCell.FormulaR1C1
ActiveCell.Offset(0, 0).Range("b1").Select

just curious

On toolbar...

Data>form

thanks DanG, but I was wondering how he was ref'ing b1 in each formula
and the focus was still being put on the correct cell ( not always b1)

I used it b/c it worked; I was really just wondering why it works.

It is based on the Offset, so it doesn't refer to cell B1, but relative to the active cell:


ActiveCell.FormulaR1C1 = tbAddress.Text
ActiveCell.Offset(0, 0).Range("b1").Select
ActiveCell.FormulaR1C1 = tbCity.Text
ActiveCell.Offset(0, 0).Range("b1").Select


So the first one is determined by the cell which has tbAddress.Text, the second reference is determined by the cell which has tbCity.Text.

HTH

Thanks for all your help. I didn't subscribe to the thread so I dint think anyone had answered. Thanks I do appreciate your responses