Populate TextBox from Module prior to opening TextBox

[Dabbler39]

OK. I concede defeat. It's your turn if you have "THE STUFF" I clearly don't have. This code works roughly 70% of the time in populating TextBox 1-20. (for the record, I need a perfect 100% of the time. I'm just picky that way; LOL).
Essentially what I am doing is this (pertinent Facts):

1. Userform (TextBox only) is populated prior to opening in order to have a TextBox that the end user can manipulate should the need arise.
2. It is populated (code below) in a module that is activated via a macro button on excel sheet (duh).

Any help greatly appreciated as I am exhausted working on this one. Seemed simple enough when I wrote it and the first few times it worked fine. Now that the end is near and I was testing all code, I tried it again and saw the flaw after several attempts.

Please Login or Register  to view this content.

[Leith Ross]

Hello Dabbler39,

Posting your workbook is the quickest way to get answer to your problem. People are not inclined to recreate your work just to test it.

[Dabbler39]

I have attached the workbook for review as per request.

Thank you.

[Leith Ross]

Hello Dabbler39,

Thanks for the workbook. I must admit I too am overwhelmed. There is a lot of code and a lot of data and so far I can't match anything up. You will have to point me in the right direction.

Which user form are you referring to in your first post?
Do I need to create a copy of the template sheet to check out the code?

[Dabbler39]

Leith. Thanks for the reply. Sorry for late response, I became deathly ill for roughly 24 hours. I lived!
Okay, here goes:
On the "Template" SHEET, the user pushes the "CONTACT INFO" (BLUE) button that takes you to the "ContactInfo" Userform. That is where the problem is. The code that takes you to the userform "ContactInfo" and populates it is in module 1 at the top which is where I believe the problem lies (code listed above). Now, what's more interesting, is........I am at work again, and alive, and tried it on my work computer and can't get it to fail. Curious to see if it fails for you.

The failure is that it doesn't always populate the "ContactInfo" userform. Sometimes it is blank when the "button is pushed." The code appears accurate to me. Just so you know........it is pulling the info to populate the userform from roughly BA1 where it is orange.

What I have done is this: by populating the textboxes in the userform when opening, the textboxes remain usable (as in, the end user can change them). When it is closed it changes the cells on the spreadsheet to match user input. All good, except on my HOME computer only now apparently, it doesn't populate the userform when opening it everytime. If it's working for you, there is an issue with my excel at home. Which is interesting as both versions are 2010. AHHHHHHHHHHHH.

[Dabbler39]

Leith Ross,

Sorry for not answering your questions adequately.

Ultimately, yes, the template will be copied repeatedly as it is just a template. However, for testing purposes, it can be used as the guinea pig. Just click on the "Contact Info" button on the top to pull up the ContactInfo userform. There may be nothing in it on the first try. Just fill out the top left 12 boxes with jibborish if they are empty.

Thanks again for your efforts.

Dabbler