Form not displaying cell data on load.

[vaximily]

I've written a form that enters data into cells via text boxes, and (I think) the code to load the data from those cells back into the form whenever it's loaded. However, when I load the form, all of the text boxes are blank.

Here's the code I use to enter data into a cell (one of many)

Please Login or Register  to view this content.

Here's the code I would expect to load the cell data back into the form when it's launched.

Please Login or Register  to view this content.

I'm sure this is a novice fix, I have basically just copied and pasted code from another form that someone else built, so any help would be appreciated.

[tigeravatar]

vaximily,

Use the UserForm_Initialize event instead of UserForm_Activate activate.

Hope this helps,
~tigeravatar

[vaximily]

vaximily,

Use the UserForm_Initialize event instead of UserForm_Activate activate.

Hope this helps,
~tigeravatar

No change. It did bring to mind the difference between loading / showing forms and such. In a nutshell, I have 2 forms (frmWizard and frmDefaults). frmWizard is displayed when the excel file is opened initially, and can be accessed again via command buttons from each worksheet.


The code to launch frmWizard when the spreadsheet is opened is:

Please Login or Register  to view this content.

The command button code to access frmWizard is:

Please Login or Register  to view this content.

From there, there is a button on frmWizard to show frmDefaults, which has this code:

Please Login or Register  to view this content.

So, maybe that will help the troubleshooting process?

[vaximily]

Looking through this, I am having a hard time understand what the following code does. However, when I comment it out, the rest of it seems to work fine.

Please Login or Register  to view this content.