By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,708 Members | 2,086 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,708 IT Pros & Developers. It's quick & easy.

Excel - Lock an ActiveX TextBox Unless It's Required?

P: 1
I'm wondering if it's possible to lock an ActiveX textbox from text entry or even being clicked on unless another cell indicates that it actually requires input from a user?

More detail: right now, I have a sheet where, based on a drop down field, the cell to the left of a textbox populates a label and the color of a cell underneath the textbox changes to green if said textbox needs input from a user.
Even more detail: the spreadsheet has a drop down list of potential applications that the user opens each day. For the applications that require login credentials, another cell may light up and say "Password:" and then the cell to the right will light up green. The textbox is on top of the green cell (BackStyle set to transparent so the user will see the color change) and when the user sees the green, they know they need to click the textbox and enter something (ex. their password).

The issue: If a user clicks on a textbox that does not need input (so it is not green at the time), the textbox BackColor turns it green. I have it set this way to match the cell behind it since it cannot be transparent like the BackStyle can be (I assume that's not possible?). This will cause some users to become confused and they may try and enter information in the textbox. It won't cause any problems with the rest of the formulas, but the least amount of confusion I can cause these users, the better!

I'm attaching an example which will hopefully help! Here are some facts about the example:
A) It doesn't look exactly like the official finished one I have with all the data, of course, so it's not lined up perfectly. I just threw it together for an example.
B) We use Excel 2003 at work, which is the version that this file will be used on, so the greens actually match on that one. I noticed they don't match on my home Excel 2010 version.
C) To view when the colors change, you'll need to change one of the drop downs to a different app such as app2 or app5.

So sorry for the long post. I wanted to give as much detail as possible so it would (hopefully) be easier for one of you experts to see a fix!
Thanks so much for any help you can give! This is the last step and then this spreadsheet will be done!!
Attached Files
File Type: xls example.xls (187.0 KB, 220 views)
Jan 16 '12 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.