Userform design from Microsoft Office Excel 2003 Programming Inside Out not working

[Stratfordoaks]

I have followed the instruction (I think) to design a simple Userform design based upon the example from the link below. I cannot work out why my form does not do what the one in the example below. When I can get it working I can then modify it to my current project.

[URL="http://msdn.microsoft.com/en-us/library/office/aa192538(v=office.11).aspx#officeexcel2003programminginsideoutch20_buildingawizard"]

My TestForm is attached and any if you run it you will see the problems I am having compared with what it should do as shown in the link above.

Regards

Stratfordoaks

[nathansav]

You need to elaborate on it.

[Stratfordoaks]

Hi nathansav

The form is started by running a macro and remains up until the user explicitly closes the form. Buttons on the form control which row of the worksheet is displayed through the form, and the form itself allows the user to enter or edit any data stored in a particular row.


Thats what it should do! In my case I want it to auto populate the ID and Name textboxes from column A and B of the worksheet depending on the RowNumber value on the form. Also the rows of the sheet to be navigated by the First, Previous, Next and Last buttons. Data entered into the ID and Name text boxes should be able to be added to the worksheet with the 'Add' button.

Does this help?

[Izandol]

You must have:

Please Login or Register  to view this content.

at the start of your module. The Initialize event must be like this:

Please Login or Register  to view this content.

Also there are no buttons that call PutData.

[Stratfordoaks]

Thankyou Izandol.

The PutData routine found in the user form module is similar to the GetData routine in that all the validations used to ensure that the value in RowNumber is valid are included. The main difference between the two routines is that the GetData routine copies information from the worksheet, whereas the PutData routine copies data to the worksheet.

I have both the PutData and GetData in the form module with neither doing the above. The GetData routine is called on 'Initialize' but nothing shows in the text boxes. As you said PutData is not called anywhere. Have you any idea how I can make these two routines work automatically as they should?

[Izandol]

Your form loads with the row number set to the first blank row therefore you have no data.

PutData must be called by your Add or Save buttons (or both). I may also recommend that your buttons should have more useful names than CommandButton7 et cetera.

[Stratfordoaks]

I have added the call PutData to the Add and Save buttons but still no data will add to the worksheet when I enter a new row number and new name. Also no data populating the form as the row number is navigated by the previous and next buttons.

[Izandol]

I recommend renaming your buttons:
btnAdd
btnSave
btnCancel
btnFirst
btnPrevious
btnLast
btnNext

You may then change the code to this for example:

Please Login or Register  to view this content.

[Stratfordoaks]

I can't thank you enough for your help Izandol. It works absolutely perfectly. I can now progress with it and add my combo's and calendar as it will end up as a form for the different sections at the golf club I manage to produce their fixtures diary for me to input onto our online calendar.

Happy Christmas from

Nigel at Stratfordoaks