Yes, its working for me,
can you please share the screenshot.
thanks
--
On Sat, Aug 27, 2016 at 10:48 PM, Manju Keerthi
wrote:
> Was it working fine for you? i am getting error in the below two line
> (error #1044) so, Else part "Range("b2").Validation.Delete" is not
> working.
>
> .Add Type:
Was it working fine for you? i am getting error in the below two line
(error #1044) so, Else part "Range("b2").Validation.Delete" is not working.
.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _
xlBetween,
Formula1:="=OFFSET(Sheet1!$A$2,,,COUNTA(Sheet1!$A$2:$A$100))"
Try enclosed one.
--
On Sat, Aug 27, 2016 at 10:01 PM, Manju Keerthi
wrote:
> Thank you so much. This helped me a lot:-)
>
> Is there any option to disappear the dropdown when user does not have any
> value in column B. instead of disable the drop down in the column B.
>
> once again Thanks a l
Thank you so much. This helped me a lot:-)
Is there any option to disappear the dropdown when user does not have any
value in column B. instead of disable the drop down in the column B.
once again Thanks a lot :-)
Keerthi
On Saturday, August 27, 2016 at 11:33:50 AM UTC+5:30, Manju Keerthi wr
HI Manju,
See this help you
--
On Sat, Aug 27, 2016 at 11:33 AM, Manju Deva wrote:
> Hi
>
>
>
> I need your help to create a macro for the below mentioned scenario.
>
>
>
> *Scenario*
>
>
>
> We need two columns namely User, drop down
>
>
>
> *“IF user enter data in User column(cells) a automa
WelCome Manju,
Keep posting and learn more and more.
Why you need this thru marco/VBA? Are you familiar with VBA or macor
--
On Sat, Aug 27, 2016 at 11:12 AM, Manju Keerthi
wrote:
> Hi,
>
> I am a beginner in excel i need your help to solve the following scenario
> i need to create a macro wh
