Hi,
Thank you in advance for your time.
I have a multi-page userform and I am having problems getting the result I am after.
I am trying to get the user to enter a four digit (numeric code) into a textbox and display the contents of that code in another textbox when the user clicks in another textbox.

I have 2 textboxes.
One textbox txt_SAC_No is for the user to enter a four digit numeric code, which should return the address in another textbox txt_Site_Address.

The lookup is located in a dynamic named range as SiteAddress which encompasses 20 columns. The first column has the code and the second column holds the actual address.

Included in the named range, I have set up a code of 0000 (zeros) and instead of having the address in it, I have a message in there to tell the user to manually type the address (overwriting the text message). The code, 0000, means that there is no pre-defined address.

I do not want the address to be updated in the source of the Vlookup as it is a ‘once only’ entry and unlikely to ever be used again.
I have searched on the web and attempted to adapt various codes, but I have been unable to get anything to work.

I have some sample code I have tried, but my attempt to adapt it to my needs has not been successful.

Worksheet where data is transferred is code named: ws_Incident_Details (which is actually sheet named “Incident Details” – but I’d like to use the ‘coded’ sheet name in case someone changes the name in the tab of the sheet

This is the current code I've tried to adapt, unsuccessfully

Please Login or Register  to view this content.
I know I have posted a post with similar request ... but nobody has looked at it, or responded to it so I thought that I'd re-post an abbreviated version and with only the one question. I can't find an option to delete the original post.

Thanking you in advance for your assistance

Cheers,
TheShyButterfly.