LinkBack URL
About LinkBacks
zak.horrocks 
Hello,
I have created a vba code to lookup data and then return it in a textbox. It works perfectly once I have typed in the textbox but appears blank before I do so.
Any suggestions or ideas to solve this?
Thanks
Z
Hello,
I have created a vba code to lookup data and then return it in a textbox. It works perfectly once I have typed in the textbox but appears blank before I do so.
Any suggestions or ideas to solve this?
Thanks
Z
Hi,
What are you expecting? And is this a Forms Control or an Activex control.
Are you implying it should already contain a value when you activate the text box. In which case where is the text you want?
If it's a worksheet cell then try using the Linked Cell property.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Hi Richard,
It is a forms control and yes, once I select an item in my combobox I'd like the information in my textbox to show straight away.
Z
Which control is it?
On my system although there is a Textbox control on the Forms menu it's greyed out, which I had always assumed was standard. Are you saying you can add this textbox or is it the similar Label control to which you refer?
Ah apologies, it's an active x control. My mistake.
In that case you can use either the Linked Cell property of the control if you want to feed it from a workbook cell, or if it should contain some text that exists in a VBA variable then use that the Form Initialise event to populate the textbox as the form is opened.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks