VBA – Make a row mandatory by a pull down with different words

[bees2cute]

I already have a few codes in my Excel document. I wanted to piggie back on code for a workbook before save.

I have a pull down that has different words. The pull down indicated server types for example database, reporting servers. What I'm looking for is when the pull down is use mandatory before a save.

The row is B1 - J1

B1 represents the pull down. I tried to change code I already have setup but that was unsuccessful because it is for a true/false statement. Any help would be lovely!! Thank you in advance.

Elizabeth

[IonutC]

Well you can do something like this..

Please Login or Register  to view this content.

if you can post your code, we can help more, because we can see your actual code and see how we can tweak it etc...

[bees2cute]

This is my true/false code:

If Worksheets("Integrations").Range("A46") = True Then
If Worksheets("Integrations").Range("G47").Value = "" Or _
Worksheets("Integrations").Range("G29").Value = "" Then
MsgBox "Please fill out these required fields on Integrations tab that are highlighted in blue."
Cancel = True
Exit Sub
End If
End If

This is what I thought I could change the True/false code to:

If Worksheets("Servers").Range("B7") = Enterprise Then
If Worksheets("Servers").Range("C7").Value = "" Or _
Worksheets("Servers").Range("D7").Value = "" Or _
Worksheets("Servers").Range("E7").Value = "" Or _
Worksheets("Servers").Range("F7").Value = "" Or _
Worksheets("Servers").Range("G7").Value = "" Or _
Worksheets("Servers").Range("H7").Value = "" Or _
Worksheets("Servers").Range("I7").Value = "" Or _
Worksheets("Servers").Range("J7").Value = "" Then
MsgBox "Please fill out these required fields on Servers tab that are highlighted in blue."
Cancel = True
Exit Sub
End If
End If

But i was wrong.

[IonutC]

FIrst you have to use code tags.
http://www.cplusplus.com/forum/articles/42672/

I don;t understand what you need to do if cell A46 is true. The same for cell B7. After Then you need at next line to write a code that is doing an action.

Like

If your eyes are green Then
You should go and shop
Elseif you should go home.

This is the basic of If statements and that is why I am asking you to provide details about the action you want to perfom if in those cells are the required string.

Also you can post your workbook by clicking Go Advanced and than you can upload a document.

[bees2cute]

This time it is not a true false statement. i need to have the row mandatory by a specific word from a pull down. Does that make sense?

[IonutC]

nope! pls attach a file...

[bees2cute]

I wasn't able to add a file but I added a screenshot.

The pull down under server type is what needs to run the mandatory rows.

Excel Document Example.png

[bees2cute]

Does the screenshot make sense?

[IonutC]

so if the cell value from B4 is Server Type then what action you want to do?

[bees2cute]

If the B4 = database, then I need the whole row (B4 through J4) associated with database to become mandatory row that needs to be file in before saving the document. Does that make sense?

[IonutC]

ok!

Please Login or Register  to view this content.

[bees2cute]

Hi sorry! I'm so late at responding.

I was unsuccessful at getting the code to work.