excel form builder

[mcgrcoAgain]

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

 

[Rickster57]

Excel Form

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.

 

[roberemok]

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

 

[browny]

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

 

[Colby]

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

 

[DanG]

On toolbar...

Data>form

 

[Colby]

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.

 

[shades]

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
________
Simca aronde

 

[mcgrcoAgain]

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