Locking a Textbox in a userform when the cell contains data

[michelle 1]

Hi I have created a userform and what i would like to do is lock Textbox 27 but only if data is contained in here, basically I do not want users to be able to change this information once entered. Can this be done and if so can you please help me be ableto do thi.

All help very much appreciated.

[TMS]

Maybe set .Enabled = False


Regards, TMS

[michelle 1]

Ah thought it might be easier than i had thought, would this allow the user to input if the cell was empty.

Thansk for responding.

[TMS]

No, you'd need to disable the textbox after it has accepted input.


Regards, TMS

[michelle 1]

Thanks for replying TMS, i have different users using the form which means disabling the textbox is not going to give me what i needed.

[Solus Rankin]

If the userform is modal they will not be able to input anything to the cell until the userform is closed. Changing the property TMS suggested above will prevent them from changing the value of the textbox.

I'm afraid I don't understand the question very well. Is that not what you were trying to do?

[michelle 1]

Hi Sorry i am new to VBA and Userforms so probably havent explained myself clearly.

I have a userform which users can enter new information or update existing information it is used by multiple users and the information is tansferred to another spredsheet. What i want is for Textbox 27 to be locked if it is not blank, basically the user will constatnty update the data as it changes however there is 1 cell which i do not want to change and that is textbox 27. i cant disable it though as a new user will initially need to populate the information. I somehow need code that says if this cell (Column 51) is not blank disable box. An extract of the code is below, its referencing whatever is in combobox 1 and finding the data.

Please Login or Register  to view this content.

Theres more lines of code but for ease i have attached the line i need help with.

hope this makes sense.

[JosephP]

if you are populating the textbox in code you can simply disable it after you populate it or is there more to the issue?

[michelle 1]

Hi Joseph, It wont always be populated by the code if its a new entry the user will need to populate the textbox for the first time with the information.

So for example a user enters new information by accessing the form and filing in all the textboxes/combobox slections. Next time month they will be updating the entry so will select their name from the checkbox 1 and all the information will be prepopulated (as per the above code) however, they may need to change some of the information such as sales figures but i do not want them to be able to update textbox 27 if its already filled. The userform is for capturing new data and updating. Hope that makes sense. I think i need code that says if cell blank then textbox 27 enabled = true, i do not know how to write it though.

thanks for helping

[JosephP]

I reckon a sample workbook would make this a lot clearer but perhaps you just need

Please Login or Register  to view this content.

[michelle 1]

Dear Joseph,

Thats exactly what i was looking for I have just added it and it works perfectly, thanks so much for your help. You are a genius!

[JosephP]

you're welcome :-)

please don't forget to mark the thread solved