LinkBack URL
About LinkBacks
Hi
I want to write a code somthing like this:
But it doesn't work!HTML Code:
Hi
I want to write a code somthing like this:
But it doesn't work!HTML Code:
Try this, right click on ComboBox3 of UserForm3 and click view code. Place your code (without the Sub CommandButton4_Click)on the line below Private Sub ComboBox3_Change() in the window that comes up. You code now becomes..
Please Login or Register to view this content.
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
Thankx. but CommandButton4 is on userform4.
I want to click on command button then another userform pops up. is that possible?
What happened when you tried it?
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
Nothing happend! My question is: when i select value in combobox3 on userform3Originally Posted by mikerickson
I'm going to userform4 to fill out the form. Then click on commandbutton4,if there is another value on combobox3, then its userform pops up.
OK, try this instead
UserForm3 Code
UserForm4 codePlease Login or Register to view this content.
Please Login or Register to view this content.
Thanks it is works but I still have problem. mabye i chose wrong way!
you see in combobox3 there are 2 values and each value has specefic userform.
I want to create a commondbutton that, when I am in userform4( for credit option) when click on commondbutton it recogonize that there is another option(Norme in this case) and notice me to going to that userform. in this case userform5.
But I dont know how can I do that?
Last edited by aidda; 08-09-2015 at 12:33 PM.
Sorry, I don't understand.
I'm trying to say what i want in a good way! I'm working on this for more than 2 days!!
Anyway,I just want commandbutton4 on userform4 check the value of combobox3 on userform3. If it has 1 value do some thing. If it has 2 value do something else
That's what the UserForm4 code I posted in post# 6 was for. When you click on CommandButton4, If ComboBox3 of UserForm3 is Company, then show Done! message, OR if it is Team, then show UserForm5.
Thats right and it is work perfectly. But if i want: if combobox3 has value 1 then check it if it has value 2 or not. In this code it is just check the name. If i want check the index, is that possible?
maybe something like this:
But this code doesn't workHTML Code:
Check where on the other form? And which form?
this is the worksheet:
https://www.dropbox.com/s/cn27nsljb4...mple.xlsm?dl=0
You need this in UserForm3 for it to work
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks