Open VBA with a Command Button on a UserForm

[geno32080]

I'm experimenting with UserForms, I built a UesrForm that loads a Main Menu Home screen when the program is launched. Since UserForms do not minimize when a Sheet is selected, you have to write in the code to include UserForm.Hide. and UserForm .Show when accessing and exiting the Sheets. I would like to be able to open the VBA Editor from a Command Button on the Main Menu. Is that possible? I have found very little about this subject on the net.
As always I thank you for any assistance.

Main Menu

(Click to open from this button)


Open This

 

[Micron]

AFAIK, it should make your code project case insensitive. It does in Access.
My comment also had to do with other code I was playing with last night, where something wasn't working because I wrote "sheet1". Changed it to "Sheet1" on a hunch and it worked. I probably should have said, "Then I was reminded that Excel seems case sensitive." Mind you, I didn't have Option Compare set at that time, so I'd have to do it again to see if it makes any difference. Probably won't though. I'm much more proficient in Access vba; thought I'd try helping out with Excel vba out of curiosity. Not sure if it's a great idea or not.

 

[Jaafar Tribak]

I'm much more proficient in Access vba; thought I'd try helping out with Excel vba out of curiosity. Not sure if it's a great idea or not.

I may be wrong but, excel forums are usually busier than their other office applications counterparts so they tend to offer more opportunities for learning, teaching and for keeping your mind sharp ?

 

[Micron]

I guess it depends on which ones you belong to. I keep busy here with Access threads (which are few and far between) and elsewhere. One of the most prevalent Access issues is when someone's workbook outgrows its capabilities, they port over to Access and wonder why tables designed like spreadsheets make poor databases! By the time you gently tell them it's designed all wrong, they're so far into it that they have little desire to start over.
Hope we're not hijacking this thread...