Posts by Raha

Raha · Oct 31st 2013

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

Raha · Oct 31st 2013

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.

If possible please help me.

Regards,
Rahaman.

Raha · Oct 31st 2013

Hi Team,

Could you please help me to create a vlookup or index-match formula with below three creteria,
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.

Kindly help & advise.

Regards,
Rahaman.

Raha · Oct 27th 2013

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.

Raha · Oct 27th 2013

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.

Kindly help and advise me.

Regards,
Rahaman.

Raha · Sep 16th 2013

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.

Raha · Sep 15th 2013

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.

Raha · Aug 24th 2013

Re: Retrieve the option button value from outside the userform

Hi Sir,

Sure, will follow as you advised.

Thanks & Regards,
Rahaman.

Raha · Aug 22nd 2013

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,

Many many thanks to you and the team who educated me about this thread.

Sure, will follow your advised when ever i work on this.....

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

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

Regards,
Rahaman.

Raha · Aug 20th 2013

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.

Raha · Aug 17th 2013

Re: Retrieve the option button value from outside the userform

Quote from Raha;679823

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.

Display More

Hi Sir,

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

Sure, i will follow your instructions without fail.

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.

Raha · Aug 15th 2013

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.

Raha · Aug 15th 2013

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.

Raha · Aug 10th 2013

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.

______________________________________________________________________________
Reposted: http://www.ozgrid.com/forum/showthread.php?t=181796

Raha · Aug 10th 2013

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.

Raha · Aug 6th 2013

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.

Raha · Aug 6th 2013

Re: Optionbutton variables to check which button has been selected

Quote from royUK;678159

What's the point in this?

Code

Set myForm = New password

Try

Code

Sub QC_for_ChaseRecons()
    Active_workbook = ActiveWorkbook.Name
    Const sPassword As String = "Rahaman*123"


    With password
        .TextBox1.PasswordChar = "*"
        .TextBox1.MaxLength = 11
        .Show    '  Password.Show
        Pass = .TextBox1.Value


        If Pass <> sPassword Then


            MsgBox "Wrong password!"
            Exit Sub
        Else
            ChaseRecons.Show
        End If
    End With
End Sub

Display More

You need to start using Option Explicit & debugging your code then you will see obvious mistakes that still exist in the rest of our code.

Display More

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.

Raha · Aug 3rd 2013

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

Code

Option Explicit


Private Sub CommandButton1_Click()


    Select Case True
    Case Me.OptionButton1
        QC_for_ChaseRecons_7753
    Case OptionButton2
        QC_for_ChaseRecons_7761
    Case OptionButton3
        QC_for_ChaseRecons_3003 ""
    Case Else
    End Select
    Unload Me
End Sub

Display More

[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]

Raha · Aug 3rd 2013

Hi Team,

Could you please help me to fix the below problems

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.

Raha · Jul 28th 2013

Re: Loop find in sheet1 & sheet2

Its your Greatness Sir,

Thank you very much.