problem regarding dropdown list

[nirankar]

i have a problem regarding dropdown list. pleasae help..

i have a drop down list .i want that if i select a value from the dropdown in column E then if the corresponding value in the G column is zero then its okk. but if the value in g column is 1 then select the next value from drop down and continue till the value in g column become zero.this i want for a specific ranges of rows..

thanks in advance..

[:) Sixthsense :)]

Please attach a sample workbook with enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Note: Please don't attach documents containing confidential data like (address, telephone, ID#s, etc.).

[nirankar]

brief sample of my problem is attached..

[:) Sixthsense :)]

Just confirm how the 1 will change to 0 if we select another item from the drop down?

[nirankar]

actually the item i select from drop down i use it in some calculation.after calculation i comapare the value with some reference with if comand.if the result is true then it will give 0 and if false then i will gate 1.

[SoulPrisoner]

Hi Nirankar,

Sorry to say but your example doesnt contain exactly precise specification of what you´re trying to achieve - there is no connection between the value and letter aswell there is no decision making formula behind the value so its hard to tell what to do to solve your issue, Pls provide more info on the whole process (maybe whole concept would help)

Best regards

Soul

[nirankar]

actually the item i select from drop down i use it in some calculation.after calculation i comapare the value with some reference with if comand.if the result is true then it will give 0 and if false then i will gate 1....

[SoulPrisoner]

Ok, well so now at least I´m getting some picture but still the issue remains the same you´re just too much general with too few things to catch up on...and btw. the main issue your example introduce is you´ve used letters as for the dropdown which (at least for me) signals there should be strings rather than values (numerics) - but that one is cleared out of the way atm.

anyways I´d love to help but some kind of general formula u´ re about to use would be nice.

Of the bat from the info you´ve provided I can be only as general as you´re at providing the info, so therefore I´d suggest you to use global variable for the dropdown list value which you can than implement in the formula (within the macro) and than get the result pasted somewhere in the sheet (or make it other variable)....

Best regards

Soul

[nirankar]

Sub Macro2()
Dim r As Long
For r = 8 To 207
With Selection
If Range(Cells(r, 10)).Value = "3cx1.5" And Cells(r, 30).Value = 0 Then
Stop
ElseIf Value = "3cx2.5" And Cells(r, 30).Value = 0 Then
Stop
ElseIf Value = "3cx4" And Cells(r, 30).Value = 0 Then
Stop
ElseIf Value = "3cx6" And Cells(r, 30).Value = 0 Then
Stop
ElseIf Value = "3cx10" And Cells(r, 30).Value = 0 Then
Stop
ElseIf Value = "3cx16" And Cells(r, 30).Value = 0 Then
Stop
ElseIf Value = "3cx25" And Cells(r, 30).Value = 0 Then
Stop
ElseIf Value = "3cx35" And Cells(r, 30).Value = 0 Then
Stop
ElseIf Value = "3cx50" And Cells(r, 30).Value = 0 Then
Stop
ElseIf Value = "3cx70" And Cells(r, 30).Value = 0 Then
Stop
ElseIf Value = "3cx95" And Cells(r, 30).Value = 0 Then
Stop
ElseIf Value = "3cx120" And Cells(r, 30).Value = 0 Then
Stop
ElseIf Value = "3cx150" And Cells(r, 30).Value = 0 Then
Stop
ElseIf Value = "3cx185" And Cells(r, 30).Value = 0 Then
Stop
ElseIf Value = "3cx225" And Cells(r, 30).Value = 0 Then
Stop
ElseIf Value = "3cx240" And Cells(r, 30).Value = 0 Then
Stop
ElseIf Value = "3cx300" And Cells(r, 30).Value = 0 Then
Stop
ElseIf Value = "3cx400" And Cells(r, 30).Value = 0 Then
Stop
ElseIf Value = "1cx120" And Cells(r, 30).Value = 0 Then
Stop
ElseIf Value = "1cx150" And Cells(r, 30).Value = 0 Then
Stop
ElseIf Value = "1cx185" And Cells(r, 30).Value = 0 Then
Stop
Else: Stop
End If

End Sub



please correct the code

[:) Sixthsense :)]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE] [/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)