Need to make a mandate field when one is selected

[mrdinhut]

Hello All,

I need to make a mandate field when one is selected in excel. So basically if the drop down from one column is selected, the users must enter data on the "other column" as well.

Any help greatly appreciated!


Ut

 

[mrdinhut]

Thank you Joe4!

I tried the code but it didn't show error when I didn't have that E19 filled (B15 selected).

Is this look right?

Ut

 

[mrdinhut]

Thank you Joe4!

I tried the code but it didn't show the error when I didn't have E19 fill (B15 selected).

Does it look right?
Ut

 

[Joe4]

Thank you Joe4!

I tried the code but it didn't show the error when I didn't have E19 fill (B15 selected).

View attachment 54611

Does it look right?
Ut

Nope. Looks like you put it in a General module, and not the "ThisWorkbook" module, like I mentioned.

If you put it in the correct module, it should show "Workbook" in the top left corner, not "(General)".

 

[mrdinhut]

I only have "Worksheet" and "General" module ....don't have "ThisWorkbook" module...

There are only 2 tabs...but one of them have ..

 

[Joe4]

I only have "Worksheet" and "General" module ....don't have "ThisWorkbook" module...

There are only 2 tabs...but one of them have ..

View attachment 54616

Yes you do. All Excel files have it. You have to be in the VB Editor to see it. You can see it under the VBA Project Explorer, where all your modules are listed:

You need to double-click on the "ThisWorkbook" module to get into it. This is where you need to paste this type of automated event procedure code.

 

[mrdinhut]

Thanks !Will try