Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
TextBoxes on a Form
Hi, I have a form with a lot of textboxes on it, they are
confirgured as Borderstyle single, and are right next to each other so that it looks like a spreadsheet, at form load I do a loop around some values ex a query from an external data source and populate the textboxes down the left hand side, to prevent people from changing the data in these textboxes I have set them as Enabled = False. But this causes the text to become grey, is there any way I can keep the text black but prevent the contents of the textbox from being changed ? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
TextBoxes on a Form
Hi Neil,
Try the Locked property. Cheers Andy Neil wrote: Hi, I have a form with a lot of textboxes on it, they are confirgured as Borderstyle single, and are right next to each other so that it looks like a spreadsheet, at form load I do a loop around some values ex a query from an external data source and populate the textboxes down the left hand side, to prevent people from changing the data in these textboxes I have set them as Enabled = False. But this causes the text to become grey, is there any way I can keep the text black but prevent the contents of the textbox from being changed ? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
TextBoxes on a Form
Another trick is to place them onto a Frame and set the Frame Enabled to
False. HTH. Best wishes Harald "Neil" skrev i melding ... Hi, I have a form with a lot of textboxes on it, they are confirgured as Borderstyle single, and are right next to each other so that it looks like a spreadsheet, at form load I do a loop around some values ex a query from an external data source and populate the textboxes down the left hand side, to prevent people from changing the data in these textboxes I have set them as Enabled = False. But this causes the text to become grey, is there any way I can keep the text black but prevent the contents of the textbox from being changed ? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
TextBoxes on a Form
Neil, you can also put them in a label and use chr(13) to do a line return
so that each entry is on a new line. Bob Flanagan Macro Systems http://www.add-ins.com Productivity add-ins and downloadable books on VB macros for Excel "Neil" wrote in message ... Hi, I have a form with a lot of textboxes on it, they are confirgured as Borderstyle single, and are right next to each other so that it looks like a spreadsheet, at form load I do a loop around some values ex a query from an external data source and populate the textboxes down the left hand side, to prevent people from changing the data in these textboxes I have set them as Enabled = False. But this causes the text to become grey, is there any way I can keep the text black but prevent the contents of the textbox from being changed ? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
TextBoxes on a Form
You can replace your textboxes with labels. Labels can be formatted to look
like your textboxes. -- Regards, Tom Ogilvy "Neil" wrote in message ... Hi, I have a form with a lot of textboxes on it, they are confirgured as Borderstyle single, and are right next to each other so that it looks like a spreadsheet, at form load I do a loop around some values ex a query from an external data source and populate the textboxes down the left hand side, to prevent people from changing the data in these textboxes I have set them as Enabled = False. But this causes the text to become grey, is there any way I can keep the text black but prevent the contents of the textbox from being changed ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Textboxes | Excel Discussion (Misc queries) | |||
tab between several textboxes | Excel Worksheet Functions | |||
textboxes | Excel Programming | |||
Form Textboxes | Excel Programming | |||
userform textboxes | Excel Programming |