# Posts by Raha

• ## Vlookup array formula with three creteria

Re: Vlookup array formula with three creteria

Quote from NBVC;689801

Maybe I am not understanding... but D2 and D3 are the same, so why should E2 and E3 be different?

Hi Sir,

I got your point, Now its working.

Thanks for giving me the hint.

Regards,
Rahaman

• ## Vlookup array formula with three creteria

Re: Vlookup array formula with three creteria

Quote from NBVC;689791

I am not sure why the result in E3 is "not working"? It did first find the a match for the left 5 chars.... why should it be otherwise?

We have a regular task where we have to lookup values for like. 12345_4795825825, 1245_9874582525 & Cm_12536.
So we are doing it manually for lengh 4 (left4) other than that we use the lookup formula.

I thought to make it one single formula for this & tried with little knowledge but its not working.

Regards,
Rahaman.

• ## Vlookup array formula with three creteria

Hi Team,

I.e 1, left(5) letters 2. left(4) letters 3.Mid(3,5).

I have attached the sample workbook for your quick review as well.

Regards,
Rahaman.

• ## Vlookup to match partial Numbers

Re: Vlookup to match partial Numbers

Quote from azumi;689211

Find the file attach please, hope it helps you

Azumi

HI Sir,

Thanks for attending my post and helping me.

Yes its working fine.

Once again thanks a lot for the help.

Regards,
Rahaman.

• ## Vlookup to match partial Numbers

Hi team,

I am looking for the vlookup formula which should lookup partial numbers, the below formula working with the text string not with the numeric.

=IFERROR(VLOOKUP(LEFT(H2,5)&"*",\$I\$2:\$J\$20,2,0),IFERROR(VLOOKUP(LEFT(H2,4)&"*",\$I\$2:\$J\$20,2,0),"Not in the "))

Colud you please advise me where i am going wrong in the formula Or advise me any other formula like index & match which should work for both text as well as numeric value.

And also attached workbook for your quick reference.

Regards,
Rahaman.

• ## Excel formula to update previous day if next day is off (satarday or sunday)

Re: Excel formula to update previous day if next day is off (satarday or sunday)

Quote from holycow;684015

This formula will convert the date in A1 to the closest weekday prior to weekend
=IF(AND(WEEKDAY(A1)>1,WEEKDAY(A1)<7),A1,A1-MOD(A1,7)-1)

Hi Sir,

Thanks for attending my post and helping me.

Its working fine for me.

Once again thank you very much.

Regards,
Rahaman.

• ## Excel formula to update previous day if next day is off (satarday or sunday)

Hi Team,

Could you please advise a excel formula to update a process name just before one day of the weekend(satarday or Sunday).

Example: My process Tat is 7th of every month, if 7th is satarday then formula should update 6th as my Tat & if 7th is sunday then formula should update the 5 as a tat.

I hereby request your goodselves to kindly help me.

Regards,
Rahaman.

• ## Retrieve the option button value from outside the userform

Re: Retrieve the option button value from outside the userform

Hi Sir,

Thanks & Regards,
Rahaman.

• ## Retrieve the option button value from outside the userform

Re: Retrieve the option button value from outside the userform

Quote from cytop;680496

An 'Option Explicit' statement is not global. It only affects the module that contains it.

There is a setting in the Tools/Options/Editor tab to make the IDE add it automatically to every module/class/userform/worksheet class module.

Just select the 'Require Variable Declaration' option...

Hi Sir,

I will always remember you guy's in my invocations.

Once again thank you very much for everything....

Regards,
Rahaman.

• ## Retrieve the option button value from outside the userform

Re: Retrieve the option button value from outside the userform

Hi Sir,

Thanks for guiding me.

Yes 100% its working fine the way how i was expected.

Once again i apologies for the inconvenience caused.

Going forward i will make sure this won't be repeated and will follow the forum rules and guidance.

Regards,
Rahaman.

• ## Retrieve the option button value from outside the userform

Re: Retrieve the option button value from outside the userform

Hi Sir,

My apologies for the inconvenience (Double posting the same thread)

My problem is i don't have private computer so in weekends i use to go cybercafe and do practice, post threads and reply.

Hope you will understand my.

Once again i am sorry for my mistake.

Regards,
Rahaman.

• ## Retrieve the option button value from outside the userform

Re: Retrieve the option button value from outside the userform

Hi Sir,

My apologies for the inconvinience,

Sure i will not post double time same issues and will do as you advised and try to learn to set the variables.

Once again i am extreamly sorry for double posting and wasting your time.

Kindly pardon me....

Thanks for helping me.

Regards,
Rahaman.

• ## Retrieve the option button value from outside the userform

Hi Team,

Could you please help me to retrieve the option button value from outside the userform (not inside the userform).

I mean from the main module i want to retrieve the value selected.

For EG: Optionbutton1 Optionbutton2 Optionbutton3

If i select Optionbutton1 then i want to retrieve this value from outside the userform.

For reference i have attached the excel file wherein i have created the three userforms that is 1. password (to mask the password 2.ChaseRecons (to use the option buttons) 3. Userform (to display the logo and selet folder option).

In userform Named ChaseRecons i have created three option buttons & want to retrieve the value of these from outside the userform not from the inside.

If i use (If ChaseRecons.optionbutton1.value=true then) its working fine inside the userform but not outside the userform.

I hereby request your goodselves to kindly help me.

Thanks in advance for the help.

Regards,
Rahaman.

• ## Optionbutton variables to check which button has been selected

Re: Optionbutton variables to check which button has been selected

Hi Sir,

My apologies for the delay in replay,

Thank you very much for attending my post and helping me.

Yes, its working 100% correct how the way i was wanted.

Once again thanks a lot for everything.

Regards,
Rahaman.

______________________________________________________________________________

• ## Vba code to retrieve the value of optionbutton from outside the userform.

Re: Vba code to retrieve the value of optionbutton from outside the userform.

Quote from cytop;678368

Just precede the Control name with the UserForm name

Code
``If UserFormName.ControlName.Value = True Then...``

Hi Sir,

My Apologies for delay in replay.

Thanks for attending my request and helping me.

The code you provided is not working outside the userform but its working inside the userform.

For your reference i have attached the macro sheet wherein i have created three userform's one for mask password named as password and second for option button named as chaseRecon and third one named as userform1.

In ChaseRecon userform i have created option button where i am trying to retrieve the the value of option button from outside the userfom.

I hereby request your goodselves to kindly help me.

Regards,
Rahaman.

• ## Vba code to retrieve the value of optionbutton from outside the userform.

Hi Team,

Could you please help me to retrieve the option button value from outside the userform (not inside the userform).

I mean from the main module i want to retrieve the value selected.

For EG: Optionbutton1 Optionbutton2 Optionbutton3

If i select Optionbutton1 then how to retrieve this value from outside the userform.

I hereby request your goodselves to kindly help me.

Thanks in advance for the help.

Regards,
Rahaman.

• ## Optionbutton variables to check which button has been selected

Re: Optionbutton variables to check which button has been selected

Hi Sir,

Apologies for the inconvenience,

I think I have been failed to explain my request to you correctly, this time i have attached screenshot for your reference. Kindly refer and help me if possible, i really don't want to give trouble to you.

I am extreamly sorry if i have given trouble to you.

Once again i hereby request your goodselves to kindly help me.

Thanks in advance for the help.

Regards,
Rahaman.

• ## Optionbutton variables to check which button has been selected

Re: Optionbutton variables to check which button has been selected

Quote from royUK;678117

You are unloading the form before the code can run. Try this

[TABLE="width: 627"]

[tr]

[td]

Hi Sir,

[/td]

[/tr]

[tr]

[td][/td]

[/tr]

[tr]

[td]

Thanks for attending my post and helping me.

[/td]

[/tr]

[tr]

[td][/td]

[/tr]

[tr]

[td]

"Yes" its working fine for option buttons that is named ChaseRecons userform but when we choose directly 1. QC_for_ChaseRecons_3003 or 2. QC_for_ChaseRecons_7753 or 3. QC_for_ChaseRecons_7761 and press run then also its working fine but skipping two userforms I.e password & Userform1 but this should not be run without skipping any of the userforms.

[/td]

[/tr]

[tr]

[td][/td]

[/tr]

[tr]

[td]

Normally when we open the excel sheet and press alt+f8 we get a window, in that window if we select directly any one among the three process its working and skipping two userform as said above.

And i have not set any code or variables to named userform1, its just unloding and moving to next code, please help me to set the variable to userform1 as well.

My need is that if we directly select and run the macro should not be ran.

[/td]

[/tr]

[tr]

[td]

Hope you will understand my request.

[/td]

[/tr]

[tr]

[td][/td]

[/tr]

[tr]

[td]

I hereby request your goodselves to kindly help me on the same.

[/td]

[/tr]

[tr]

[td][/td]

[/tr]

[tr]

[td]

Note:- Sure i will donate as much as i can.

[/td]

[/tr]

[tr]

[td][/td]

[/tr]

[tr]

[td]

Regards,

[/td]

[/tr]

[tr]

[td]

Rahaman

[/td]

[/tr]

[/TABLE]

• ## Optionbutton variables to check which button has been selected

Hi Team,

1. I am not able to set the variables for ChaseRecons from outside the (userform 2--- Optionbuttons) to check which button has selected

2. If we Select directly the QC_for_ChaseRecons_3003 or QC_for_ChaseRecons_7753 or QC_for_ChaseRecons_7761 and press run it will skip the two userforms I.e (1).Password and (2).ChaseRecons

3.If we select directly the QC_for_ChaseRecons_3003 or QC_for_ChaseRecons_7753 or QC_for_ChaseRecons_7761 macro should not run

4. Macro should include all the three userforms in the procedure without fail.

I hereby request your good selves to kindly help me on these.

Thanks in advance for the help.

Regards,
Rahaman.

• ## Loop find in sheet1 & sheet2

Re: Loop find in sheet1 &amp; sheet2