In the UserForm_Initialize() function is set the first record to Rows(2) in the Named Range "DataBase". Then I call the LoadRecord function which should load the values in Rows(2) but it loads the last viewed record. Where am I going wrong? Thanks for your help in advance! Example attached.LESSONS LEARNED DATABASE FORUM SUBMITTAL.xlsm
Please Login or Register to view this content.Please Login or Register to view this content.
When you click the OK or Cancel buttons, your code just hides the userform. Then when you show it again, the userform is made visible, but its' Initialize procedure is not run again.
If you want it to re-initialize every time, unload the userform.Please Login or Register to view this content.
Please Login or Register to view this content.
Alternatively, have it reload the row(2) record in the UserForm_Activate procedure.
Last edited by AlphaFrog; 03-05-2014 at 02:35 PM.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks