Add, search and edit using a user form

[clint182]

Hi All,
I have a workbook that i would like to automate using a user form. The workbook consistests of 5 sheets and each sheet having 8 coloumns of data.

Basically i would like to develop a user form that would:
* Have a dropdown menu to select which sheet to add the data to, once selected and 'submit' button is clicked the info would be added
* Ability to search for a keyword' and then bring the line of data up in the user form so it can be edited

I have attached a copy of what i have started with if it is any assistance.


Book1 - Copy.xlsThanks

[AlphaFrog]

Here's an example userform with code that you may find useful.
Edit Records in Excel Worksheet Data Entry Form

[humdingaling]

You will need to add the Combo box into form then have mechanism to load row

     
    cboSheet.RowSource = "Data!A1:A5"

i created a seperate sheet called Data to load the new combo box

then to direct where the information goes
under submit command

    Sheets(cboSheet.Text).Select
    lRow = ActiveSheet.UsedRange.Rows.Count
    
    Range("A" & lRow + 1).Select

this will use the next available row into sheet you have selected

[HaHoBe]

Hi, clint182,

have you considered using Excel built-in DataMask (which isnīt available on the ribbon but maybe activated through the options)? Will work on any sheet where it is called and may recognise the data/table without programming...

Ciao,
Holger

[clint182]

Thanks all!