Dear Bheema,
See attached sheet.
*Private Sub UserForm_activate()
marqueeText = This is a test of the Marquee
Do
For m = 1 To Len(marqueeText)
UserForm1.Label1.Caption = Mid(marqueeText, m, 10)
For i = 60 To 55 Step -1
'Change in accordance
Please help me.
On Tue, Sep 6, 2011 at 10:37 AM, Mudit Gandhi forumu...@gmail.com wrote:
Hi group
I am beginner at macro so i want a pdf tutorials in which i could get all
the formulaes used in macro with examples.
Thanks for ur help
Mudit
--
Thanks dguillett1 for your assistance, but i am not sure this is the
right track. Perhaps it is my lack of knowledge, but i cannot this
code to work. What i need is to make sure that some code is completely
excecuted before a next part of code is processed. How can i control
the VBA code to wait
Hi Mudit,
See Below Links
http://www.excel-vba.com/
http://www.ozgrid.com/VBA/
http://www.exceltip.com/book-1931841047.html
http://www.cpearson.com/excel/Downloads.aspx
http://www.contextures.com/tiptech.html
*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile
Dear Experts,
Will somebody inform me that why my request is not getting your kind
attention, please?
Regards,
Zafar Iqbal
On Mon, Sep 5, 2011 at 11:00 AM, Zafar Iqbal ziqba...@gmail.com wrote:
Dear Experts,
Still waiting for your kind support.
Regards,
Zafar Iqbal
hi expert,
still waiting
Divaker
On Mon, Sep 5, 2011 at 12:47 PM, Divaker Pandey divake...@gmail.com wrote:
Hi Expert,
still waiting for ur solution
On Fri, Sep 2, 2011 at 4:12 PM, Divaker Pandey divake...@gmail.com wrote:
Hi Expert.
Is there any way to write and read cookies through
Hi Noorain,
The code in the weblink did not work.
This just created a new workbook with a single sheet.
Appreciate for any other options..
Regards,
Sridhar BL
--
--
Some important links for excel users:
1.
Hi Group,
I have check boxes in the form below , what i want is if i update a value
in Update Currency Type in one Check box the value of the Other Check box
Only Indian Currency shud be same, please let me know how to do it.
Thanks
Prasad.
--
Dear Surya,
Please see attached sheet..
Type value in one text box and press tab...
--
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/
On Tue, Sep 6,
[Little bit correction]
Please consider it..
On Tue, Sep 6, 2011 at 3:37 PM, Mr Excellent suryaprasad...@gmail.comwrote:
Hi Group,
I have check boxes in the form below , what i want is if i update a value
in Update Currency Type in one Check box the value of the Other Check box
Only
Hi Mrinal,
Free online converter please try it.
http://www.pdftoexcelonline.com/
--
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/
On Tue, Sep 6, 2011
This is actually not working i am not able to use it. pls help me
On Sun, Sep 4, 2011 at 9:46 PM, ashish koul koul.ash...@gmail.com wrote:
check the link
http://www.andypope.info/charts/piezeros.htm
On Sun, Sep 4, 2011 at 8:58 PM, sandhya jain sanya...@gmail.com wrote:
Hi All,
please
Hi everyone,
Looks like nobody has had any experience of this, so I've searched
elsewhere and found the answer.
The key to this problem is that I was looking at it in terms of
points. If you change the way that you are looking at the problem to
be in terms of segments, it becomes A LOT easier.
Thank so muchh. Noorainji
On Tue, Sep 6, 2011 at 11:48 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Bheema,
See attached sheet.
*Private Sub UserForm_activate()
marqueeText = This is a test of the Marquee
Do
For m = 1 To
I am not understanding. Perhaps a sample file dguillett1 @gmail.com
-Original Message-
From: John Holland
Sent: Tuesday, September 06, 2011 2:14 AM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ processor to slow for proper sequential
processing of vba code ?
Thanks
Pls. I need a form to adjust to the data widths of different sizes.
Its a part of the form basing on your solution I have to prepare that
form of 3 pages. pls provide solution.
--
--
Some important links for excel
Perhaps because you said to avoid vba. What excel version. Perhaps a sample
file.
From: Zafar Iqbal
Sent: Tuesday, September 06, 2011 2:58 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Conditional Formatting
Dear Experts,
Will somebody inform me that why my request is
Dear Bheema,
please share attachement with any rough example..
--
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/
On Tue, Sep 6, 2011 at 6:56 PM, Bheema
sure guruji, pls have a look at my attachment and provide me solution.
I marked the cell data with Redcolor. Those are to be adjusted to their
width and remaining to their respective widths. Kindly provide solution.
On Tue, Sep 6, 2011 at 7:06 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
I made a userform with a command button called PRINT and wrote the
following:
me.printform
but it will directly printing the form without showing the Print
dialogue box. how to get that dialogue box on command.click event.
--
I have a database in my excel. On userform i pasted a command button
with the name UPDATE. on the click event, the data to the
corresponding File no. will populate in respective textfields. My
intention is to, if any modify in one or two textfields, when I click
on the update button the same
A simple way to do this is to select the column headers(top row marked a,b,c,)
desiredplace you mouse on the line between any 2 and click. Record a macro and
assign to a shape or button, if desired.
From: Shankar Bheema
Sent: Tuesday, September 06, 2011 8:48 AM
To:
try the attachment
On Tue, Sep 6, 2011 at 4:06 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Hi Mrinal,
Free online converter please try it.
http://www.pdftoexcelonline.com/
--
Thanks regards,
Noorain Ansari
I made a userform. linked it with the datasheet. the filenumber acts
as a bridge between userform and datasheet. I have to make the file
number unique in excel. Because the duplicate numbers also accepting
by the datasheet. If it happened so, my intention will not fulfill.
So kindly provide
Hi John,
please try this see if it helps
after u copy and paste first image add
Application.CutCopyMode = False
this way u can check if loop is working properly or not
use below statement to make it wait for 5 second then resume ur code
Application.Wait Now + TimeValue(00:00:05)
also
try the attached file
On Tue, Sep 6, 2011 at 4:26 PM, sandhya jain sanya...@gmail.com wrote:
sometime its a requirement to use pie.
On Sun, Sep 4, 2011 at 10:54 PM, Deepak Pal Singh
deepaktheind...@gmail.com wrote:
Its better to not to use pie chart when you have many data points...
Dear Bheema,
Try it...
Private Sub CommandButton1_Click()
Application.Dialogs(xlDialogPrint).Show
End Sub
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/
On
Hey All,
We need MIS Exe having good knowledge of Excel and Access. Forward you’re CV
on my e-mail address (vikask...@gmail.com) or call me 9911868518
Company Name : AuthBridge Research Services (p) Ltd.
Company Website : www.AuthBridge.com
Role:MIS Executive
Job Description:
1) Prepare
Dear Bheema,
Please try it and see attached sheet
Sub Autofit()
If TypeName(Selection) = Range Then
Selection.Columns.Autofit
End If
End Sub
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
Hi All,
Please help me to put the IF function for the below table. If the table
value is 0 the product should not be there
Attached the file for u r reference
Tech OFM Apps Systems Result should be 1 2 0 1 Tech;OFM;Systems 1 2 0 1
Tech;OFM;Systems 1 2 1 0 Tech;OFM;Apps 1 0 0 1 Tech Systems
result by IF function
regards,
Pawel
From: anu gomathi anugomathi.d...@gmail.com
To: excel-macros@googlegroups.com
Sent: Tuesday, September 6, 2011 9:00 PM
Subject: $$Excel-Macros$$ Help in IF Function
Hi All,
Please help me to put the IF function for the
I would adise you to do the following:
1. Concatenate the three cells I.e., region, province and barangay in both
the Sheets.
2. Now use index and match.
Let me know if this clear.
Regards,
Joe
On Tuesday, September 6, 2011, John Alliage Tinio Morales
alliage.mora...@gmail.com wrote:
Hi, I am
What could be the reason for increase in excel file? I have a file with size of
4.5 MB, but data contents are not that much.
Best Regards,
Amit Desai
Disclaimer: This message and its attachments contain confidential information
and may also contain legally
*Experience:* 2 - 7 Years
*Location:* Delhi
*Compensation:* Rupees 4,00,000 - 5,50,000
*Education:* UG - B.B.A - Management,B.Com - Commerce PG - M.Com -
Commerce,MBA/PGDM - Any Specialization, Finance
*Industry Type:* Auto/Auto Ancillary
*Role:* Finance Exec.
*Functional Area:* Accounts, Finance,
2011/9/7 Amit Desai (MERU) amit.de...@merucabs.com
What could be the reason for increase in excel file? I have a file with
size of 4.5 MB, but data contents are not that much.
** **
You can do the following:
- First you file your virus scanner.
- Then select all the rows and columns
Thanks a lot pawel
Regards
Anu
On Wed, Sep 7, 2011 at 12:41 AM, pawel lupinski lupins...@yahoo.com wrote:
result by IF function
regards,
Pawel
--
*From:* anu gomathi anugomathi.d...@gmail.com
*To:* excel-macros@googlegroups.com
*Sent:* Tuesday, September
36 matches
Mail list logo