updating a parent workbook from a child workbook via Userform

Really embarrassed to even but this lousy bit of non working code out here..
I have several instances of the child workbook with bunches of input forms. Each user inputs their own data into their own instance of this workbook. They can add records, delete records or modify existing records. Once done, upon exit, the instances of their sheet gets emailed to me so I can update the main workbook (called parent)
I have a unique Identifier that simply is the name of the show concatenated with the start date. I want to use that field as the lookup into the parent sheet and edit the record if it is found in the parent workbook OR append it to the bottom if it is a new show.... this is the code I got and the workbooks are attached. Thanks!

Please Login or Register  to view this content.

Hi, smooth_beaker,

please add code-tags around the button_click-procedure as requested per Forum Rule #3. This makes both reading and copying the code a lot easier.

Ciao,
Holger

Hi, smooth_beaker,

maybe add a Cancel/Close button to your form as well:

Please Login or Register  to view this content.

Ciao,
Holger

Hi, smoothsmooth_beaker,

maybe something like this:

Please Login or Register  to view this content.

Ciao,
Holger

Hi, smooth_beaker,

if you copied all the code this line is in between an With..End With-statement, so Error 91 should not occur (thatīs at least what the theory says about it). I ran the code on your sample files in Excel2007 and could not find an error with it. Maybe you command these lines of code out and see if the rest works like it should:

Please Login or Register  to view this content.

Please mind that nearly the same code lines appear for adding the data a bit further on down on in the code.

HTH,
Holger

Hi, pram,

welcome to ExcelForum.

The code you posted canīt work as the lines are commented out and will not get any action from the event (these lines of code should appear in green if you havenīt changed the settings on your PC for the VBE).

You need to get the apostrophes away in order for the event to recognize commands that are to be executed. Make sure that the UserForm16 is in the workbook as that should be loaded (or adapt the proper name of the userform you want to show on opening).

If you really use Excel2003 as indicated by the profile you may get a note on opening the file. You would need to enter the VBE afterwards and adjust the settings for the Office libraries as VBA will upgrade any time but canīt adjust the links to lower versions (Excel2003 is XL11, Excel2007 XL12, 2010 XL14).

Ciao,
Holger