Hi
I am currently having problems to Show and Hide UserForm and worksheet properly. When I open the workbook everything works fine. The Userorm opens and the Worksheet is hidden as I want it. When I click the Show Worksheet the worksheet appears. However when I click the Close UserForm the UserForm and Worksheet disappears completely!
I am very new to VBA.
Here is the code I am using:
Thanx
Please Login or Register to view this content.
Last edited by DawidV; 02-26-2017 at 07:17 AM. Reason: To add Code Tags to code
Hi, good morning and welcome to the forum,
Could you attach a sample file (non private data please), will make it easier to see what is wrong. Your code doesn't tell me all.
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
HiOriginally Posted by Keebellah
Thanx. I am very very new to using Forums for help.
Could u please help me with what you want me to send you. specially the how part? I have no idea how to do thet.
Thanx
You must send me the file you are working with, I cannot imagine or guess what YOU have.
Just attach the file, If you read the forum's instructions. it is all told there.
I have attached a file explaining it a little
Last edited by Keebellah; 02-25-2017 at 11:10 AM. Reason: forgot attachment
Ok.
Thanx will try to attach the complete file.
If you want plse give me an email address. It will be easier to communicate. I will not abuse the privilege that i have that
are willing to assist me.
Thanx
Dawid
Let me take a look first. I'll let you know
Sorry All.
Please ensure that you use code tags.
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.
Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.
Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here
(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Hi
I am currently having problems to Show and Hide UserForm and worksheet properly. When I open the workbook everything works fine. The Userorm opens and the Worksheet is hidden as I want it. When I click the Show Worksheet the worksheet appears. However when I click the Close UserForm the UserForm and Worksheet disappears completely!
I am very new to VBA.
Here is the code I am using:
ThanxPlease Login or Register to view this content.
This should do it
Thanx a mill!!
It is working as I wanted it to work!!!!
I looked at the code and I take it the change was made to the [CODE]UserForm_Terminate()[CODE] proc?
Always thought I did/forgot something in the code or did something stupid!!!!!!! Am so new to this that I find it very difficult to figure out what does what when I try to go through the code later on.
Am still trying to figure out a way to go through the code step by step and seeing what it does. Maybe debug???
What I am trying to say is I am looking for a way to maybe go step by step through the program to see if it does what it must do. Don't know if I am explaining myself properly here.
Again thanx for the help. As you can see in the code there is still a lot to be done so you do know that i will be coming back to u again.......
Greetings for now
If you want to go though the code step-by-step.
Open VBA editor and select the macro then press F8
Your first mistake was in making the application FALSE after closing the userform it hides it an your userform is gone too
Ok thanx.
I will now be able to carry on again. will post again if i get stuck.
Will do as you advise to view step by step.
Good to hear, I'm sure you can do it
You know where to find us / me.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks