Hi,
We are trying to create a toggle button to auto collapse/expand multiple
groups dynamically.
At the moment we have to name each group in the Names Manager and then
manually have an if statement in VBA code where hard-code each groups name.
However, we will have more than 100 groups so it mak
Thank you very much.
I'm learning VBA
Thanks
N.Sundarvelan
9600160150
On 19 August 2016 at 22:34, mrExcel4u wrote:
> Hi,
> Please use the below mentioned code on Add command Button click
>
> Private Sub CommandButton1_Click()
>
> Dim Rcount As Integer
>
> Rcount = Sheet1.Cells(Rows.Count, 1).E
Hi,
Please use the below mentioned code on Add command Button click
Private Sub CommandButton1_Click()
Dim Rcount As Integer
Rcount = Sheet1.Cells(Rows.Count, 1).End(xlUp).Row
Rcount = Rcount + 1
Range("b" & Rcount).Value = Me.TextBox1.Value
ActiveCell.Offset(0, 2).Value = Me.TextBox2.Value
Ra
Dear Friends,
I'm trying to learn VBA,
PFA, i'm trying to add data from userform text to excel table.
Please help
Thanks
N.Sundarvelan
9600160150
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
ht
Great!!
ᐧ
On Tue, Jan 20, 2015 at 6:34 PM, sach so wrote:
> Dear Vabz,
>
> Thanks! It works as i required.
>
> Regards,
> Sachin
>
> On Sunday, January 18, 2015 at 7:40:16 PM UTC+5:30, Vabz wrote:
>>
>> Sach,
>>
>> Amended code to suits your need..
>>
>> Cheers!!
>>
>> On Fri, Jan 16, 2015 at 5:
Dear Vabz,
Thanks! It works as i required.
Regards,
Sachin
On Sunday, January 18, 2015 at 7:40:16 PM UTC+5:30, Vabz wrote:
>
> Sach,
>
> Amended code to suits your need..
>
> Cheers!!
>
> On Fri, Jan 16, 2015 at 5:28 PM, sach so >
> wrote:
>
>> Dear Expert,
>>
>> I required some changes in VBA
Sach,
Amended code to suits your need..
Cheers!!
On Fri, Jan 16, 2015 at 5:28 PM, sach so wrote:
> Dear Expert,
>
> I required some changes in VBA, file attached here. I have data sheet,
> for Input i have input sheet & for output have output sheet. when I run
> macro i will get output.
>
> *
Dear Expert,
I required some changes in VBA, file attached here. I have data sheet, for
Input i have input sheet & for output have output sheet. when I run macro i
will get output.
*My requirment- *In data sheet if product & product id is allocated then
macro need to pick next (non allocated)
Hi
Can you share sample data with desired result..
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Tue, Nov 11, 2014 at 1:17 PM, Mandeep Baluja
wrote:
> I have made this code for I have two worksheets that are in the same
> workbook.
>
> I want to check
I have made this code for I have two worksheets that are in the same
workbook.
I want to check the values of WS 2, Column B to WS 1, Column B. If there is
a match, then copy/write the row of WS1 to WS 2. but in my code I am
retreiving the values through cells one by one I want *if cell matches
Dear Pavan,
Please use..
Sub Close_excelApplication()
Application.Quit
End Sub
--
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com
On Tue, May 29, 2012 at 3:18 PM, Pavan Chowdary
wrote:
> Hi,
>
> This is pavan.
> Here i had a doubt. is there any vba co
This simple one liner leaves
sub closewholeexcelapplication()
application.quit
end sub
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: pavan chowdary
Sent: Thursday, March 08, 2012 3:48 AM
To: excel-macros
Subject: $$Excel-Macros$$ VBA Help
Hi,
This is pavan
2012/3/9 NOORAIN ANSARI
> Dear pavan,
>
> Apart of Mahesh code,
> You can use also below code to close all excel application even
> Thisworkbook also
>
> Sub Excel_Application_Close()
> Dim wb As Workbook
> For Each wb In ActiveWorkbook
> wb.Close Savechanges:=True
> Next
> Application.Quit
> End
Dear pavan,
Apart of Mahesh code,
You can use also below code to close all excel application even
Thisworkbook also
Sub Excel_Application_Close()
Dim wb As Workbook
For Each wb In ActiveWorkbook
wb.Close Savechanges:=True
Next
Application.Quit
End Sub
On Thu, Mar 8, 2012 at 3:18 PM, pavan chowd
Hi Pavan
Try
Public Sub CloseAll()
Dim WB As Workbook
Application.DisplayAlerts = False
For Each WB In Workbooks
If Not WB.Name = ThisWorkbook.Name Then
WB.Close SaveChanges:=False ' Or True if you want changes saved
End If
Next WB
ThisWorkbook.Close SaveChanges:=False
End Sub
HTH
Mahesh
On Thu
Hi,
This is pavan.
Here i had a doubt. is there any vba code to close whole excel application?
if it there you please let me know by reply to this mail.
Thanks,
Pavan.
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Pl
[mailto:excel-macros@googlegroups.com] On
Behalf Of Paul Schreiner
Sent: Friday, September 09, 2011 9:42 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ vba help
If you do it that way, you're going to skip some rows:
first loop:
i = 1, selects 1 to 200
i = i + 200 = 201
second
long as ever you can.” - John Wesley
-
From: ashish koul
To: excel-macros@googlegroups.com
Sent: Fri, September 9, 2011 11:40:55 AM
Subject: Re: $$Excel-Macros$$ vba help
Sub breaksheet_data()
For i = 1 To 2000
She
Sub breaksheet_data()
For i = 1 To 2000
Sheets(1).Rows(i & ":" & i + 199).Copy
Sheets.Add After:=Sheets(Sheets.Count)
Cells(1, 1).Select
ActiveSheet.Paste
i = i + 200
Next
End Sub
On Fri, Sep 9, 2011 at 12:47 PM, naresh v wrote:
> Hi Group,
>
>I have one excel sheet with 2000 records.
Hi Group,
I have one excel sheet with 2000 records. i want to split those records.
those 2000 records should copy into moresheets
for ex:
main sheet -- 2000 records;
sheet1 -- 1 to 200
sheet2 -- 201 to 400
sheet3 -- 401 to 600
.
.
.
sheet10 -- 1801 to 2000
thanks in advance
regards,
n
refer attachment
On Sat, Oct 23, 2010 at 9:35 AM, C.G.Kumar wrote:
> You can use EDATE if using Excel 2007. Rest you can define in Macro.
>
>
> Regards,
>
> C.G.Kumar
>
>
> On Sat, Oct 23, 2010 at 12:07 AM, halpie97 wrote:
>
>> I'm a beginner with VBA and looking for some guidance in how to
>>
You can use EDATE if using Excel 2007. Rest you can define in Macro.
Regards,
C.G.Kumar
On Sat, Oct 23, 2010 at 12:07 AM, halpie97 wrote:
> I'm a beginner with VBA and looking for some guidance in how to
> establish what I'm trying to do.
>
> Column A Column B Column C Column D
> 1/15/
I'm a beginner with VBA and looking for some guidance in how to
establish what I'm trying to do.
Column A Column B Column C Column D
1/15/2010 6/30/2009
3/2/2010 4/15/2008
I'm trying to create a VBA formula that will do the following in
columns C and D:
Column C should just be one yea
Dear All,
I am having two lists, which contains trial balances.
Every month one or two codes are getting added in the TB which i have
to identify.
Now to identify the new codes we use vlookup function on both the
sheets and where #N/A Error comes we come to know that these are the
newly added c
Hello Dear,
You can bind the uses of VBA for specific industry.I am working with
mainframe and
we have to record the jcl log,We send all jcl log to the VBA Admin to
arrange it date/time wise
according to time.
but my others friend are working in Other domain,told me that vba is also
important for
Hi Chethan,
Finance, Consulting - Analytics industries (KPO-BPO) uses VBA most, and I
would suggest you to update your resume in some top job portals and then
you'll automatic receive job opportunities.
--
Thanks & Regards,
DILIP KUMAR PANDEY
MBA-HR,B.Com(Hons),BCA
Mobile: +91 9810929744
dil
e("A1").Value = UCase(MonthOfSales)
converts "MonthOfSales" to uppercase and puts it in Cell A1.
P
From: Shiv Goel
To: excel-macros@googlegroups.com
Sent: Thu, February 11, 2010 2:34:06 AM
Subject: $$Excel-Macros$$ VBA Help
Option Explicit
Sub
Option Explicit
Sub InputSales()
Dim MonthOfSales As String
Dim SalesData(1 to 4)
MonthOfSales = InputBox(prompt:= "Enter month of sales", _
title:= "Month")
SalesData(1) =InputBox(prompt:= "Enter sales for week 1")
SalesData(2) =InputBox(prompt:= "Enter sales for w
Hi Everybody,
i want to know which industry use VBA for excel programming most.?
So that i can apply for jobs who does VBA excel programming and also suggest
me the links or websites to apply jobs for VBA excel programming.
Thanks in advance.
Regards,
Chethan
--
29 matches
Mail list logo
