| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Prefill a text box on a form
I want to prefill a textbox with data from the excel file and I do not want
the user to be able to change the data in this box. How do i do this? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Prefill a text box on a form
Here's what you need to do.
Assume that the data you want to use to pre-fill the text box is in cell A2 Textbox1.Text=Range("A2").Value Secondly, set the 'Locked' or 'Enabled' property of the text box to TRUE. -- Pranav Vaidya VBA Developer PN, MH-India If you think my answer is useful, please rate this post as an ANSWER!! "Mike H." wrote: I want to prefill a textbox with data from the excel file and I do not want the user to be able to change the data in this box. How do i do this? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Prefill a text box on a form
The cell has numbers in it. Should it prefill with numbers okay or do I need
to convert to text via the str() function? "Pranav Vaidya" wrote: Here's what you need to do. Assume that the data you want to use to pre-fill the text box is in cell A2 Textbox1.Text=Range("A2").Value Secondly, set the 'Locked' or 'Enabled' property of the text box to TRUE. -- Pranav Vaidya VBA Developer PN, MH-India If you think my answer is useful, please rate this post as an ANSWER!! "Mike H." wrote: I want to prefill a textbox with data from the excel file and I do not want the user to be able to change the data in this box. How do i do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell validation prefill | Excel Discussion (Misc queries) | |||
| Automatic cell validation prefill by entering first letter | Excel Discussion (Misc queries) | |||
| How can I prefill a text field with leading 0s? | Excel Worksheet Functions | |||
| converting numbers to text and prefill text field with 0's | Excel Discussion (Misc queries) | |||
| How do I convert dollars and cents to text, and prefill the cell . | Excel Worksheet Functions | |||
Hybrid Mode
