How to prevent compilation of a field on condition based

[wippis]

Hi everybody,

I try to write the following VBA code in order to prevent the compilation of the fields "Imponibile" and "IVA" when "TipoDocumentazione"= Ricevuta (see attached image). Immagine.png

I have two types of problem:
1) the fields "Imponibile" and "IVA" can still be compiled
2) doing modification on other fields on excel file, the "non corresponding types - runtime error" appears

Where I am wrong?

Please Login or Register  to view this content.

[AlphaFrog]

Try this. If your sheet is protected, uncomment the two green lines and change the password to suit.

Please Login or Register  to view this content.

[mikerickson]

Locking a cell has no effect unless and until a worksheet is Protected. The Lock property determines what happens to that cell when the sheet is protected. It does nothing until the sheet is protected.

This approach might work for you.

Please Login or Register  to view this content.

[mikerickson]

duplicate error

[wippis]

It seems it works only in some situations.. (it make not sense, I know..).. see attached imageImmagine.png

[wippis]

Same behaviour...

[mikerickson]

I thought that if the cell in column G said "Ricevuta" you wanted the cells in uncompleted, i.e. empty.

[wippis]

I thought that if the cell in column G said "Ricevuta" you wanted the cells in uncompleted, i.e. empty.

yes, I want that.

It seems there is something wrong in the code because actually I can fill the "Imponibile" and "IVA" fields; I attach the code

Please Login or Register  to view this content.

and the table screenshot
Immagine.png