Disable a command button yet enable it based on other conditions

[chin67326]

Hello, the attached workbook will open a userform. I am trying to construct an argument that ensures the below takes place:

1. When a row in the listbox has all three elements(i.e. Number, Item and Type) then the Save command button should be disabled. Therefore if the user is browsing the listbox items row by row by clicking on each row, whenever a fully populated row (with all three elements) is clicked then the save button should show as disabled.

2. For rows that have elements missing, the Save command button will only be enabled when all three textboxes contain data, then the user can click the save button to save the data.

So far I am able to achieve only criteria #2 above as you can see. However I am unable to construct the code to achieve criteria #1 and unfortunately when I click on a fully populated row with all three elements, the save command button shows as enabled.

Would appreciate your help!

[JapanDave]

I don't follow, you say that when 3 items are there the save button disabled, but say when 3 items have the save button show? Is No. 1 contradicting No. 2?

[chin67326]

I don't follow, you say that when 3 items are there the save button disabled, but say when 3 items have the save button show? Is No. 1 contradicting No. 2?

When the listbox shows a row with 3 items (number, item and type) the save button should show as disabled (this means the data is already there and nothing else is needed).

When the three textboxes are all empty or some are empty, the save button should show as disabled.

For listbox rows that are missing data, the save button should only come alive and show as enabled when the user has entered data in the textboxes so he can click the button and save the data.

[JapanDave]

Are you saying when the line with 3 items in the LIST box is selected?

[chin67326]

Are you saying when the line with 3 items in the LIST box is selected?

Yes, selecting any line (or row) of data in the listbox would show the save button as disabled - i.e. whether a line has all the data or some data, when the line is clicked with the mouse and selected, the save button will be disabled.

However, for a Line (or row) that is missing data, the save button will ONLY be enabled and come alive after the user has inputted data in ALL THREE textboxes, and the user can then click save then the save button will then be disabled.

[JapanDave]

Replace the code for txtType_Change to this,

Please Login or Register  to view this content.

[simcode]

Hi, chin
try this

[chin67326]

Are you saying when the line with 3 items in the LIST box is selected?

Yes, selecting any line (or row) of data in the listbox would show the save button as disabled.

[JapanDave]

Sorry you will have to use the below if statement on all three text boxes not just the one I stated.

Please Login or Register  to view this content.

[JapanDave]

Like this

Please Login or Register  to view this content.

[chin67326]

Hi, chin
try this

Hi simcode, thanks but when I select a line of data from the listbox in your workbook, the save button shows as enabled and therefore one can change data in the textbox and click save and overwrite the data. I will try JapanDave's advice and will let you know if it works.

[simcode]

Sorry, i haven't noticed it before submit
try

Please Login or Register  to view this content.

[chin67326]

JapanDave, thank you! Your solution is exactly what I need. It worked fine.

Good day to you!

[JapanDave]

Sorry, i haven't noticed it before submit
try

Please Login or Register  to view this content.

Simcode, that still won't work I believe.

[JapanDave]

JapanDave, thank you! Your solution is exactly what I need. It worked fine.

Good day to you!

No worries.

[simcode]

A row in the listbox has all three elements, and you find an element is wrong, you want modify it, what would you do. Now the save button is disabled

[chin67326]

A row in the listbox has all three elements, and you find an element is wrong, you want modify it, what would you do. Now the save button is disabled

That is a valid point; in that case the user will have to notify the administrator of that workbook.

[JapanDave]

You could add a modify button with administrator privileges.

[chin67326]

You could add a modify button with administrator privileges.

Yes, that one I can take care of. Cheers guys!

[JapanDave]

Don't forget to rep those who helped. Cheers.