textbox enabled

J

Jaye7

Well-known Member
Joined
Jul 7, 2010
Messages
1,069
Hi All,

I set the value of textbox1.enabled=false on my userform.

Is there a way that I can set the forecolor font to black so that the text isn't faded out.

I have tried setting the textbox1.forecolor=&H80000008& but it remains faded, as obviously the textbox is not enabled.

I don't want people to be able to enter the textbox but I want the font to remain dark, not faded out.

If you could help with my other post also it would be much appreciated.

http://www.mrexcel.com/forum/showthread.php?t=539178
 

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".
Sort by date Sort by votes
I have found a way to get around this problem.

I have a textbox which I set the tag to B, when the textbox tag equals B then the script redirects as follows.

Code: 
textbox30.tag="B"
 
 
Private Sub TextBox2_Enter() ' this script for all relevent textboxes
If TextBox30.Tag = "B" Then
TextBox1.SetFocus
End If
End Sub

only when I click on my commandbutton to Modify will it give me access to the textboxes as the commandbutton changes the textboxes tag to H.

then when I click on my Save commandbutton or Cancel commandbutton it then resets textbox30.tag to "B" so that if they try and click on the textboxes it then redirects again.

I managed to work something out for myself for a change.
 
Upvote 0
You must log in or register to reply here.

Similar threads

P
  • Question Question
If and ElseIf confusion !
Replies
5
Views
287
Micron
M
I
  • Solved
Textbox on userform not updating when navigating through records
2
Replies
10
Views
519
ipbr21054
I
P
  • Solved
Textbox BackColor Problem
Replies
5
Views
516
rlv01
R
A
  • Question Question
possible calculation in listbox for debit , credit when search based on textbox ?
Replies
0
Views
442
abdelfattah
A
P
  • Question Question
Exiting a Textbox Problem
2
Replies
10
Views
695
Pacman52
P

Forum statistics

Threads
1,224,541
Messages
6,179,418
Members
452,912
Latest member
alicemil

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top