textbox visibility based on specific text/word of other textbox
suppose in my UserForm there have 3 text box, in Textbox1 i can write anything, like: Apple, Ball, Cat, 01-Jan-2019, ect. anything...
if I write Cat then Textbox2 & Textbox3 will be visible and able to write anything like: Apple, Ball, Cat, 01-Jan-2019
how can i do that?
TIA
Last edited by emmr; 07-31-2019 at 02:49 AM.
Assuming you want TextBox 2 & 3 to appear when TextBox1 is not empty and disappear when it is, you could use this:
BSB
Please Login or Register to view this content.
tnx a lot, its solved
suppose in my UserForm there have 3 text box, in Textbox1 i can write anything, like: Apple, Ball, Cat, 01-Jan-2019, ect. anything...
if I write Cat in textbox1 then Textbox2 & Textbox3 will be writable other wise that textbox remain non writable,
how can i do that?
TIA
You said this was solved ...
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Maybe this?
BSBPlease Login or Register to view this content.
Last edited by BadlySpelledBuoy; 07-31-2019 at 01:28 PM.
AliGW: after getting the solution im saying this as solved
BadlySpelledBuoy:this code is not working, could u plz help with other code, tnx
But you are still asking for help, so you should remove the solved tag until you have received that help, otherwise members may not look at the thread.
did it, tnx for your support,
suppose in my UserForm there have 3 text box, in Textbox1 i can write anything, like: Apple, Ball, Cat, 01-Jan-2019, ect. anything...
if I write Cat in textbox1 then Textbox2 & Textbox3 will be writable other wise that textbox remain non writable,
how can i do that?
TIA
Can you be a bit more specific about what "not working" means?Originally Posted by emmr
BadlySpelledBuoy:
Is there an error message? If so, what does it say?
Does it not do what you need? If so, you need to give more detail on exactly what you want it to do.
BSB
BadlySpelledBuoy Sir: visible is working at my tool, textbox2 & textbox3 visible only for a specific word "Cat" at textbox1,
now i'm looking for other option that, all textbox will be visible all time but after writing "Cat" at textbox1 only, i'll be able to write anything at textbox2 & textbox3 other that "Cat" that textbox will be non writable.
Tnx
So if TextBox1 says "Cat" then TextBox2 and TextBox3 will be active and can have any value typed in. But if TextBox1 does not say "Cat" then the other textboxes will be locked from editing?
BSB
yes sir, im expecting just like this
Then maybe this?
BSBPlease Login or Register to view this content.
Re your PM ("sir im sry to inform you, this code is not working, im able to write anything anytime in textbox2 & textbox3 which is not depend on anything, looking for your next advice"), can you attach your file. It will be far easier to provide a solution if we can see that.
BSB
sir this is the file
check the attached picture non writable pic saying that, you cant write anything there, even mouse point cant insert there,
for specific word "passport" you can write anything there.
Dis you try typing cat into the box?
actually this is not my file, so i cant do anything, but i'm expecting like this
So what you meant all along was you want the textboxes greyed out when disabled?
Try this:
See attached.Please Login or Register to view this content.
BSB
thanks for your endless effort sir, actually color is not necessary, you cant click on that box/ you cant use your cursor/mouse pointer on that box until the word "Cat" on textbox1, that's way its look gray, tnx sir
sir at last i got that, what im expecting (and use your color), but not 100%
from the beginning textbox2 & textbox3 need to be locked
if i write a letter/word or at least a space[] on textbox1 then textbox2 & textbox3 become locked
means when textbox1 is blank then textbox2 & textbox3 should be locked
if i write anything other than "Cat" textbox2 & textbox3 remain locked
and if i write "Cant" only and only then textbox2 & textbox3 will be open to write.
but it will help me, tnx a lot for your support.
im looking for your next help. tnx again
Then all you need to do is set the "Enabled" property to false in the VBE properties window as per the attached.
Or you could set it during the UserForm Initialize event with the lines below:
Does that do what you need??Please Login or Register to view this content.
BSB
owow tnx a lot sir, but i didn't find
how to set it during the UserForm Initialize event with the lines below
TextBox2.Enabled = False
TextBox3.Enabled = False
Add this to your UserForm module:
BSBPlease Login or Register to view this content.
tnx a lot sir, its fully done..
sir how to get date picker option if Microsoft MonthView Control is not available in my Excel
TIA
That is a completely different questions to the one this thread has been dealing with. I'd therefore suggest starting a new thread for this question.
BSB
ok sir, tnx a lot
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks