Hi,
Please help me to write a code for
I would like to restrict the user's ability to input data in cell B1 (Cell B1 is having drop down list) until cell A1 is populated with a number. How is this done?
Thank you for your help.
Hi,
Please help me to write a code for
I would like to restrict the user's ability to input data in cell B1 (Cell B1 is having drop down list) until cell A1 is populated with a number. How is this done?
Thank you for your help.
Assume that your B1 Validation List Consist the below reference to list in dropdown..
$F$1:$F$3
Change the B1 Validation List range reference to
=IF(A1<>"",$F$1:$F$3,"")
And give ok…
Check and confirm
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Thanks for your immediate response,
but when I am using this formula I am getting error : "The list source must be delimited list, or a reference to single row or column"
Please help me
Thank you for your help
Yes because you are using Multiple column reference in the Validation List.
If you see in my suggested reference $F$1:$F$3 I just used a single column Reference (i.e.) Column F alone.
So don't use multiple column reference in Validation List.
No i also used only one column I copied same formula but it is not working it is showing same error
Thank you
Please share the range reference with us which you are trying to add in the Validation List...
Validation list Range is F1 to F3
Thank you
It should work please share the complete formula or screenshot or sample workbook for getting better understanding
Thank you so much for your timely help and sorry for bothering you
Please find attached excel file
Once again I am explaining what I am expecting
In column A i have drop down list when I entered some thing in cell A1 then only Cell B1 will allow to enter some data (column B is also having drop down list). If A1 is 'blank' or '0' then if user trying to enter any value in B1 it has to show error.
Thank you
Thanks for the sample file. Now I understand your problem clearly… Just do it for a single cell then afterwards we copy and paste it for the rest of the cells. Please follow the below steps…
Place the cursor in B1 Cell ALONE>>Press Alt+D+L>>Settings>>Allow>>List>>Copy and paste the below formula
=IF(A1="","",Stage)
Click Ok…
Now check deleting the a1 cell value and come to B1 and check the Drop Down item. It will work nicely.
Now copy the B1 cell and Select B2 to B4 and paste.
Thank you so much for your help it is working.
But when A1 is empty in B1 drop down list is not coming this is fine, but when i entered manually some value (whatever is there in the list) in B1 it is taking that value, I dont want to enter any value in B1 if A1 is empty or Zero
Thank you
In this case we have to go for VBA for clearing the contents of the next column when the Column-A cell goes empty.
Copy the below code and Do right click on sheet tab and select view code and paste the below code. Return to excel and check
Please Login or Register to view this content.
Thank you so much but it is not working. When I entered Zero in A1 if is there any values already entered in B1 is clearing. But when I am trying to enter manually some numbers in B1 it is taking though there is a zero in A1 it is not showing any error.
What I am expecting is: if I entered in Cell A1 is zero or I left blank then I am trying to enter some value in B1 it has to show error like 'A1 is zero/Balnk you cant enter any value in this cell'
Sorry for bothering you
Thank you
Simple just remove the Zero from your Column-A Validation List. When Zero don’t have any roll then why we have to keep it in Column-A validation List Selection?
Sorry I think I am wasting your time
Actually this excel file is for validating some physical registers
column B is dependent column on Column A. Here column A is we are looking completeness of one indicator in the register, if the indicator is complete they will enter 1, if indicator is not complete or not entered they will enter zero. If they will enter '1' in column A means there is some information for that indicator, then we have to enter that actual information in column B. if they enter '0'or left blank means there is no data for that indicator so there is no need to enter any thing in column B.
Why we are giving validation is we are not allowing the user to enter any data in column B until unless the column A is '1'
I think now I explained clearly
Sorry for bothering you
Hi,
Please check the attached file.
See the steps in Method tab and a sample in the next tab
Last edited by aganesan99; 11-11-2013 at 08:34 AM.
Thank you so much
Thank you so much,
For this same validation is there any possible to put a drop down in Column B
Thanks
Surely, I will provide you the expected solution by tomorrow since now I am out of office and dont have any access to system.
Sent from mobile device.
Thank you so much for your timely help
Hi,
Please see the attached file.
In the Method tab I have made some changes in the steps.
It'll help you
If it is useful click on "Add Reputation"
Thanks,
aganesan99
Last edited by aganesan99; 11-11-2013 at 09:15 AM.
Thank you so much it is working
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks