Dear Vijaykumar
As said earlier, I get excel files (mostly from Japanese clients) and
they have a tendency to use lots of text boxes to make a good looking
table or some forms to collect data. The method used by them is
"Insert > Text box > Horizontal text box". The text boxes are NOT
created usin
Dear Solomon,
There are many websites, including this Group are there to learn Advanced Excel.
See the footnote of this email message where some links are given to
learn Excel and Macros.Alternatively, you can search "Advanced Excel
Tutorials" over Google / other search engines.
In order to learn
Hi Neil,
You can use name range for this, for example Range("Test1").select here
Test1 is a name range. Hope this will help you.
Regards,
Deepak
On Sat, Sep 11, 2010 at 2:13 PM, neil johnson wrote:
> Hi Everyone,
>
> How can we make dynamic range in excel vba. Please explain it . How can we
> f
Hi Solomon,
That's really Nice !!
Please start contributing and helping others by solving their queries
and start educating yourself. This way, you can encounter various
types of realistic Excel queries and can learn advanced Excel.
Googling is also a good option. :)
Best of luck,
DILIPande
Hello,
I want to know how you created text box in excel.In that only real problem
lies. please tell me how you create the text box in excel.
Regards
Vijaykumar
On Sat, Sep 11, 2010 at 7:56 PM, Chandru wrote:
> Dear VijayKumar
>
> Thanks for taking good interest in the problem and sharing
Hi All!
I would like to learn Advanced Excel and Macros also. I know Vlookup &
Hlookup and other formulas. Myself am a bit strong in excel but I want to
improve more and would like to achieve more success.
Please guide me!
Regards,
Solomon
On Sat, Sep 11, 2010 at 7:26 PM, Dilip Pandey wrote:
Change the cell format to "Number" by right clicking on cell.
Regards,
Saurabh Patel
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of viju mobile
Sent: Saturday, September 11, 2010 5:39 PM
To: excel-macros@googlegroups.com
Subject
Dear VijayKumar
Thanks for taking good interest in the problem and sharing your
valuable knowledge and time.
As you said, track changes does not work on any formatting changes.
But I am not able to accept that keeping a text in text box and
changing that text as a formatting operation. Basically
Hi Greg,
Please find the attached workbook and let me know if this solves your purpose :)
Best Regards,
DILIPandey
On 9/9/10, gdbar...@googlemail.com wrote:
> Thanks Dilip - I've uploaded the file 'sample.xlsx'
>
> Regards, Greg
>
>
> On 9 Sep, 15:52, Dilip Pandey wrote:
>> Hi Greg,
>>
>> Ple
Hi All,
I am trying to input 20 digit number in a column. But it does not
enter it correctly.
Please guide me.
Regards,
Vijay
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and lin
Hi Everyone,
How can we make dynamic range in excel vba. Please explain it . How can we
fetch date in *user form by using dynamic rage in excel* *in vba coding *.
Please solve this problem .
Thanks and Regards
--
-
Hello,
When you do track changes your workbook, Excel track and highlights the
changes made by you or everyone (as set) in the workbook.Others cannot use
and make changes or corrections if the work book is not shared with them. By
activating track changes excel by default shares the workbook.But
Wish *VERY HAPPY EID* to all members of group
Thanks
Kalyan
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN gro
13 matches
Mail list logo
