Data Entry on Form

**Vetequk** · 02-28-2010, 02:00 PM

I have managed to write some code to allow me to enter data via a form, but I would like to be able to update existing records and have the text boxes synchronise to the data sheet if the name is picked out from the combo.

Not sure if I should use a combo or list box. I have attached the file.

Thanks

Vetequk

**rwgrietveld** · 02-28-2010, 03:34 PM

I've used listboxes in combination with dynamic named ranges.

See the attachement and tell me what you think.
named ranges e.g
CompNo: =OFFSET(Sheet1!$A$1,1,0,COUNTA(Sheet1!$A:$A)-1,1)

Piece of code:

Please Login or Register  to view this content.

**royUK** · 02-28-2010, 03:36 PM

Also , see the DataBaseForm example

http://excel-it.com/vba_examples.htm

**Vetequk** · 02-28-2010, 04:58 PM

I was looking for a type of auto fill, that when you commence typing the name the list box would give you all the options. then if you clicked one of the names in the list box you could just amend that record but if the name was not already in the data base it would add it as a new record.

thanks

Vetequk

**rwgrietveld** · 03-01-2010, 06:52 AM

That is a std property of a COMBOBOX.

Replace all the textboxes with comboboxes.

**rwgrietveld** · 03-01-2010, 06:53 AM

That is a std property of a COMBOBOX.

Replace all the textboxes with comboboxes.

To test you'll need to extnd the single character values to multple character values
2 Wrong, 200323 OK