Excel VBA Lab - An Excel VBA Macro help Group

Contact owners and managers

1–30 of 312

EXCEL

Excel VBA Lab is started with a view to providing a qualitative solution to users of MS Excel through MS Excel formula & Excel VBA Macros.

Participate in query to learn & excel in MS Excel.

** To participate, Let's keep it simple.

*1* New Post for new query, no query in others post,

*2* Keep subject small & mention your requirements in body with sample data in excel file as attachment,

*3* No cross posting in multiple forums (it makes multiple brainer to work on the same problem who can work diff queries to resolve multiple queries),

*4* Do not address to particular members directly,

*5* No SPAM-Job posting (except MS Excel & VBA related),

*6* Give some time to get response, do not expect immediate reply,

*7* Very Important Acknowledge contribution of members good or Bad.

*8* No password breaking request.(If you do so your A/c will be suspended)

*** Keep Posting.

(please note we are not charging for any support provided by this group if you receive any communication on behalf of this group then notify us immediately)

Cheers!!

https://blog.vba.co.in/

https://blog.vba.co.in/

0 selected

8/21/19

How do I compare absolute difference between column and one target cell, and afterward, sort by Abs diff?

Hi all I would like to use VBA to compare the absolute difference between one column of values vs one

unread,

How do I compare absolute difference between column and one target cell, and afterward, sort by Abs diff?

Hi all I would like to use VBA to compare the absolute difference between one column of values vs one

8/21/19

helicoptersound

8/21/19

Pop-up error message when cells are blank

Hi...is this group still active? I need some help....please see my attached file.. If the users fill

unread,

Pop-up error message when cells are blank

Hi...is this group still active? I need some help....please see my attached file.. If the users fill

8/21/19

5/4/18

Date formula complicated Challengeing Required

Any Solution? On Mon, Apr 30, 2018 at 7:29 PM, amar takale <amart...@gmail.com> wrote: -- Are

unread,

Date formula complicated Challengeing Required

Any Solution? On Mon, Apr 30, 2018 at 7:29 PM, amar takale <amart...@gmail.com> wrote: -- Are

5/4/18

12/26/16

CRM (Customer relationship management ) excel template

Dear All Friends, Goog Morning Can anyone send me CRM (Customer relationship management ) excel

unread,

CRM (Customer relationship management ) excel template

Dear All Friends, Goog Morning Can anyone send me CRM (Customer relationship management ) excel

12/26/16

10/20/16

VBA Code for search any string (text) & filter data automatic

unread,

VBA Code for search any string (text) & filter data automatic

10/20/16

Dheeraj Bankoti

10/11/16

Fwd: $$Excel-Macros$$ Conditional calculation required for multiple criteria.

HI IS IT POSSIBLE? ---------- Forwarded message ---------- From: Dheeraj Bankoti <dbankoti@gmail.

unread,locked,

Fwd: $$Excel-Macros$$ Conditional calculation required for multiple criteria.

HI IS IT POSSIBLE? ---------- Forwarded message ---------- From: Dheeraj Bankoti <dbankoti@gmail.

10/11/16

Dheeraj Bankoti

10/4/16

Conditional calculation required for multiple criteria

Dear Experts, I am seeking your help for Conditional calculation in attached file. Regards Dheeraj

unread,

Conditional calculation required for multiple criteria

Dear Experts, I am seeking your help for Conditional calculation in attached file. Regards Dheeraj

10/4/16

9/28/16

Query for Internet Explorer

I am waiting sir! From: Manish Mahto [mailto:helpand...@gmail.com] Sent: Monday, September 26,

unread,

Query for Internet Explorer

I am waiting sir! From: Manish Mahto [mailto:helpand...@gmail.com] Sent: Monday, September 26,

9/28/16

Dheeraj Bankoti2

9/6/16

Single Quotes Added to Email Address

Hi, Is possible to short it out? Thanks ---------- Forwarded message ---------- From: Dheeraj Bankoti

unread,

Single Quotes Added to Email Address

Hi, Is possible to short it out? Thanks ---------- Forwarded message ---------- From: Dheeraj Bankoti

9/6/16

9/4/16

Happy Independence Day

On Monday, August 15, 2016 at 10:05:50 AM UTC+5:30, Ashish Kumar wrote: Dear All, Happy Independence

unread,

Happy Independence Day

On Monday, August 15, 2016 at 10:05:50 AM UTC+5:30, Ashish Kumar wrote: Dear All, Happy Independence

9/4/16

Nitin Balodi, Ashish Kumar2

9/4/16

Changing Region and Language Setting using VBA

Hi, Do you know which regional setting in your registry? Regards Ashish Kumar On Thursday, August 25,

unread,

Changing Region and Language Setting using VBA

Hi, Do you know which regional setting in your registry? Regards Ashish Kumar On Thursday, August 25,

9/4/16

Jaime Hardeman, Ashish Kumar2

9/4/16

IF with Vlookup

Hi, Share your query with the question and required output. Regards Ashish Kumar On Thursday, August

unread,

IF with Vlookup

Hi, Share your query with the question and required output. Regards Ashish Kumar On Thursday, August

9/4/16

Ashu K, Ashish Kumar3

8/24/16

How to know the Cell Address where Error will be Showing.

Hi, Check this..! Note : Please visit the group page for download the sheet. Regards Ashish Kumar On

unread,

How to know the Cell Address where Error will be Showing.

Hi, Check this..! Note : Please visit the group page for download the sheet. Regards Ashish Kumar On

8/24/16

amar takale, Ashish Kumar4

8/2/16

Text bold in sentence

Dear Friends,Good morning Any idea? On Fri, Jul 29, 2016 at 5:51 PM, amar takale <amartakale@gmail

unread,

Text bold in sentence

Dear Friends,Good morning Any idea? On Fri, Jul 29, 2016 at 5:51 PM, amar takale <amartakale@gmail

8/2/16

Alex O, Ashish Kumar3

7/15/16

send active sheet as values vba

Hi Alex O, waiting for your reply. Regards Ashish Kumar On Friday, July 8, 2016 at 8:46:49 PM UTC+5:

unread,

send active sheet as values vba

Hi Alex O, waiting for your reply. Regards Ashish Kumar On Friday, July 8, 2016 at 8:46:49 PM UTC+5:

7/15/16

Ashu K, Ashish Kumar2

7/15/16

Space Between Names

Hi, Check this. Regards Ashish Kumar

unread,

Space Between Names

Hi, Check this. Regards Ashish Kumar

7/15/16

Ashish Kumar, Ashu K2

7/13/16

Received. Thanks Ashu Kenith.

unread,

Received. Thanks Ashu Kenith.

7/13/16

Vibhuti Shrotriya, Ashish Bhalara3

7/8/16

Paste Data as per Count

Hi Ashish Bhalara, It's working good. Thanks for the same. Thanks & Regards Vibhuti S. On

unread,

Paste Data as per Count

Hi Ashish Bhalara, It's working good. Thanks for the same. Thanks & Regards Vibhuti S. On

7/8/16

amar takale, Vaibhav Joshi13

7/2/16

Extract Latest 24 Date after Criteria match from database

ok I will try On Fri, Jul 1, 2016 at 8:43 PM, Vaibhav Joshi <v...@vabs.in> wrote: use small

unread,

Extract Latest 24 Date after Criteria match from database

ok I will try On Fri, Jul 1, 2016 at 8:43 PM, Vaibhav Joshi <v...@vabs.in> wrote: use small

7/2/16

Vaibhav Joshi, bigsmile6783

6/25/16

Fwd: Excel VBA Macro Help Group [excelvbalab] V LOOOK UP QUERY

PFA First of all make sure that you are giving exact name in drop down list as in Table header to

unread,

Fwd: Excel VBA Macro Help Group [excelvbalab] V LOOOK UP QUERY

PFA First of all make sure that you are giving exact name in drop down list as in Table header to

6/25/16

Ashish Bhalara, vabs3

6/24/16

Use Sumproduct function in VBA for sum of last date value

Yes, It's resolve now. I use SumIf instead of SumProduct as below. ttlPay = Application.

unread,

Use Sumproduct function in VBA for sum of last date value

Yes, It's resolve now. I use SumIf instead of SumProduct as below. ttlPay = Application.

v...@vabs.in

6/24/16

Ashu K, … Ashish Bhalara4

6/13/16

How can I find the highest Alpha Numeric value

Hi Ashu, Try below array function by Ctr+Shift+Enter =MAX(--RIGHT(A1:A10,8)) Regards Ashish Bhalara

unread,

How can I find the highest Alpha Numeric value

Hi Ashu, Try below array function by Ctr+Shift+Enter =MAX(--RIGHT(A1:A10,8)) Regards Ashish Bhalara

6/13/16

aditya prakash, Ashish Kumar4

6/10/16

I need help on the formula =Gender(A2,B2)

Hi, Elaborate more your query and share output example. Regards Ashish Kumar On 9 June 2016 at 20:08,

unread,

I need help on the formula =Gender(A2,B2)

Hi, Elaborate more your query and share output example. Regards Ashish Kumar On 9 June 2016 at 20:08,

6/10/16

Ashu K, … Ashish Kumar3

6/2/16

Hi, Use this....!! =TEXT(B2-A2,"[h]:MM:SS") Regards Ashish Kumar

unread,

Hi, Use this....!! =TEXT(B2-A2,"[h]:MM:SS") Regards Ashish Kumar

6/2/16

My Excel, Vaibhav Joshi5

5/30/16

need a macro to send emails

Thank You sir On Mon, May 30, 2016 at 5:09 PM, Vaibhav Joshi <v...@vabs.in> wrote: not sure, you

unread,

need a macro to send emails

Thank You sir On Mon, May 30, 2016 at 5:09 PM, Vaibhav Joshi <v...@vabs.in> wrote: not sure, you

5/30/16

SUDHIR VERMA, … Ashish Kumar4

5/29/16

SIR HELP REQUIRED

It's very fine. Thanks you Sir. From: Ashish Bhalara Sent: ‎28-‎05-‎2016 11:54 To: Excel VBA Lab

unread,

SIR HELP REQUIRED

It's very fine. Thanks you Sir. From: Ashish Bhalara Sent: ‎28-‎05-‎2016 11:54 To: Excel VBA Lab

5/29/16

Vibhuti Shrotriya, GENIUS UFO3

5/25/16

How to Create Hyperlinks

Thanks..! Working perfect for me. Thanks & Regards Vibhuti S.

unread,

How to Create Hyperlinks

Thanks..! Working perfect for me. Thanks & Regards Vibhuti S.

5/25/16

asha kala, Ashish Kumar2

5/17/16

HI, Check this. Try to resolve your query with the help of this example. Note : Please visit the

unread,

HI, Check this. Try to resolve your query with the help of this example. Note : Please visit the

5/17/16

Nur Hossain, Vaibhav Joshi5

5/16/16

Priority setting based on five conditions

Cheers!! great this helped you.. On Mon, May 16, 2016 at 8:06 PM, Nur Hossain <nur...@gmail.com

unread,

Priority setting based on five conditions

Cheers!! great this helped you.. On Mon, May 16, 2016 at 8:06 PM, Nur Hossain <nur...@gmail.com

v...@vabs.in

5/16/16

Vibhuti Shrotriya, Ashish Kumar2

5/13/16

Extract Dates from String

Hi, Use this formula : =+DATE(YEAR(A2),MONTH(A2),DAY(A2)) Regards Ashish Kumar On Friday, May 13,

unread,

Extract Dates from String

Hi, Use this formula : =+DATE(YEAR(A2),MONTH(A2),DAY(A2)) Regards Ashish Kumar On Friday, May 13,

5/13/16

Search

Clear search

Close search

Google apps

Main menu