Modal setting on UserForm Stops Working

[geno32080]

I'm almost done with this project. One final hang up. From the Main Menu UserForm5 , When I click on the Jacksonville Command Button2, it opens the Jacksonville Sheet, Sheet2, I can fill in info as needed, how ever, if I click on the main menu command button2 on Sheet 2 and return to the main menu UserForm5, then come back to the Jacksonville Sheet I can no longer enter info in the cells unless I click on the clear cells button on the jacksonville page, then i can enter info except now I have lost the previous info.
I have the UserForm5 Show Modal to false, but I'm lost now, it works once, but if I leave the sheet and come back it doesn't. Any Idea what's going on here?
This is the last step for this project, and I'm frustrated.

 

[NdNoviceHlp]

Trial removing the "active sheets" with the specific sheet (ie. sheet2) and specifying ranges (ie. Sheet2.Range("B9:AB40").Clearcontents ). Maybe using activate would be better (ie. Sheet2.Activate) or maybe selecting a specific cell (ie. Sheet2.Range("A1").Select ??? HTH. Dave

 

[geno32080]

Trial removing the "active sheets" with the specific sheet (ie. sheet2) and specifying ranges (ie. Sheet2.Range("B9:AB40").Clearcontents ). Maybe using activate would be better (ie. Sheet2.Activate) or maybe selecting a specific cell (ie. Sheet2.Range("A1").Select ??? HTH. Dave

Trial removing the "active sheets" with the specific sheet (ie. sheet2) and specifying ranges (ie. Sheet2.Range("B9:AB40").Clearcontents ). Maybe using activate would be better (ie. Sheet2.Activate) or maybe selecting a specific cell (ie. Sheet2.Range("A1").Select ??? HTH. Dave

Okay I will give that a shot, I'll let you know the results. Sometimes another set of eyes gives the best result.. Thanks

 

[geno32080]

Trial removing the "active sheets" with the specific sheet (ie. sheet2) and specifying ranges (ie. Sheet2.Range("B9:AB40").Clearcontents ). Maybe using activate would be better (ie. Sheet2.Activate) or maybe selecting a specific cell (ie. Sheet2.Range("A1").Select ??? HTH. Dave

Well I tried every combo with that strategy. Seemed like it was going to work. But, VBA threw out nothing but errors.
Back to the drawing board.

 

[geno32080]

Trial removing the "active sheets" with the specific sheet (ie. sheet2) and specifying ranges (ie. Sheet2.Range("B9:AB40").Clearcontents ). Maybe using activate would be better (ie. Sheet2.Activate) or maybe selecting a specific cell (ie. Sheet2.Range("A1").Select ??? HTH. Dave

Solved...
When using a UserForm as a Main Menu with CommandButtons to navigate to various Sheets, you must do two things,
1. Set ShowModal to False in UserForm properties
2. Use Me.Hide in the code vs UserForm.Hide.
That combination fixed the issue with not being able to enter info onto the sheet after clicking on the Command Button to access the Sheet.