Search Function Loads TextBox's Values, but I need user not to change those tb

JessYoungCQE

New Member
Joined
Jan 23, 2022
Messages
1
Office Version
  1. 2016
Platform
  1. Windows
Long time listener, first time caller. I am a low end novice with C++ training, but that was a decade ago. I apologize, and please correct, if I commit any forum faux pas.

I have two userforms named NewItemEntryUF, and ExitEditCageUF. Both utilize Sheet3(ActiveQLog).
NewItemEntryUF - User fills out form with required information to electronically add non-conforming product to quarantine cage.
ExitEditCageUF - User uses a search bar and associated list box to select item via the information input in NewItemEntryUF.

Some of the NewItemEntryUF values load into 4 text boxes on ExitEditCageUF, all in frame (InactiveFrame). I do not want these values to be changed, but additional information (not loaded in NewItemEntryUF) to be filled out including the engineering disposition, sort results, RMA#, etc. I am also afraid that even if the button does not load the changed values into the sheet, that the ability to change these boxes, will open the user up to confusion about what they are actually updating in the sheet.

Is it possible to launch an error message if they click into the box, or to error during a change event inside the textbox and restore the value to what it was before they tabbed out of the box. I have a similar issue on NewItemEntryUF where a textbox auto-populates the current date and time, but because my serialization of entry items is dependent on the date, and because we have strict product aging limitations, I need that box to only input the current date and time. (Perhaps I just load that as a variable in the sheet without textbox input?) From the picture you can see I was trying to use labels that update via selection.

Make it a great Day, Jess Young
 

Attachments

  • ExitForever.PNG
    ExitForever.PNG
    58.1 KB · Views: 8

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".

Marc L

Banned User
Joined
Apr 5, 2021
Messages
2,030
Office Version
  1. 2010
Platform
  1. Windows
Just use a label rather than a text box for any value an user must do not change …​
 

Micron

Well-known Member
Joined
Jun 3, 2015
Messages
3,455
Office Version
  1. 365
Platform
  1. Windows
Set .Enabled property to false/no?
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,167,514
Messages
5,854,175
Members
431,623
Latest member
ncorkren

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
Top