Hi Sonal,
The query attached by you has been solved per your expectations and attached
herewith. Thanks.
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On 9/21/09, Sonal Gadgil wrote:
>
> Hi...
>
> I am new
You are welcome!!
Let the "group" know, if you face any challenge. Thanks
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On 9/21/09, Manoj Lambhate wrote:
>
> Hi Dilip,
>
> Thanks a lot.
> I have taken a
Thanks for the help.
So, as recommended I added the code to the my "dataEnter"
CommandButton like so:
Private Sub dataEnter_Click()
Day = MovementData.dateDay.Value
Range("a1") = Day
End Sub
It came back in error when I ran it (compile error, argument not
optional). Bear with me as I ba
Paul,
Thanks for your help. i integrated your suggestions into the code and
it works a treat!
Much appreciated.
Nick
On Sep 22, 3:20 am, Paul Schreiner wrote:
> the problem is that you're using a Selectionchange event.
> this event is triggered WHENEVER you change ANY cell!
>
> it doesn't eve
Thank you in advance because I have been stuck for 2 hours on this
issue.
The process formats data into a Pivot table because of X/Y needs to be
read / formatted. Everything for the most part works correctly except
when I want to format the actual graph. The legend, font, title, etc
won't chang
Hi,
I need your help on the attached sample sheet. I have used the concatenate &
indirect combination logic to get the desire comments as outcome , but my
problem is that I have 300 rows & 30 sheets in a workbook with this logic ,
it is increasing the size of my file as I have a total of 30 sh
Daniel,
Thank you for the suggestion, but I am not sure where the file is that
you are suggesting I look at.
I have the following code, but it does not seem to work:
Set Source = Range(Cells(3, 10), Cells((LastRow + 1), LastColumn))
X = 1
Y = 1
ReDim Data(Source.Count)
LastColumn = Acti
I dont know why in some computers excel stores date in mm/dd/ and
in some as dd/mm/
BUT
You can convert the same to any format without using any formula or a
macro.
Just select the column containing the data (Date. in whatever format!
like 1.13.2009, or 13-1-2009, or 13/1\2009)
Go to
Friend!
If you are not confused about the functions =TEXT() (in excel) and
=Format() in VBA, (like i was confused) You can just rename your
macro in the code module by pressing ALT+F11 to get the function
"Forrmat" working again.
On Sep 21, 5:41 pm, Doug wrote:
> I'm so annoyed at myself! I r
Hi dear Sonal,
You can refer to Help on VLOOKUP (or COUNTIF whichever is easy!)
function in excel (excel as I feel has got excellent help file)
I would put the required formula in your attachment and upload it back
but I do not see the "Attach" option here!
I had asked for help but no one seems
the problem is that you're using a Selectionchange event.
this event is triggered WHENEVER you change ANY cell!
it doesn't even have to be related to $B$4 !!
so first of all, you don't really care if they SELECT another cell,
you only care if they CHANGE cell B4,
so I'd suggest changing the even
Hi...
I am new in this group.
I am facing one proble while working in the excel.
I am having two excel files where i have to map the customer based on
customer name by matching customer name manually.
Now, in case there is any macro available which help me to search & map
names this will be gre
Hello excel guru's,
i recently joined this group and have picked up quite a bit of useful
stuff! i do however have a little problem and would be greatly
appreciated if someone could advise on what may be the cause.
i have a listbox in cell B4 which has three options: Roof, Floor, Roof
+Floor. With
On Mon, Sep 21, 2009 at 6:30 PM, Sonia Singla wrote:
> Hi ashish
> to do this first u select the data then click right button and go to format
> cells.
> Then select custom in number tab.
> there type "dd/mm/"
>
> Sonia
>
>
>
> On Mon, Sep 21, 2009 at 6:19 PM, Sonia Singla wrote:
>
>> Hi Ash
Paul,
I placed the string in the Workbook_Activate sub in the ThisWorkbook
module and it works.
Thanks.
Doug
Paul Schreiner wrote:
> Not sure why it doesn't work for you.
>
> I did this:
>
> In a module I called "Declarations", I added:
>
>
> Public Variable_Public
> Global Variable_Global
>
>
OK... let's take a look at this.
In the Visual Basic Editor, make sure you Properties window is turned on.
(Either select View-> Properties, or hit an F4)
And your Project Explorer is open (View -> Project Explorer or Ctrl-R)
Now, select your userform in the Project Explorer under "Forms".
Now, s
*opps gave u wrong file*
*please check attached file (updated)*
Thanks & Regards,
Harmeet Singh
Sent via BlackBerry Wireless
On Mon, Sep 21, 2009 at 6:56 PM, Harmeet Singh wrote:
> *See attached file and let me if it helps..*
> Thanks & Regards,
>
> Harmeet Singh
>
> Sent via Bla
*See attached file and let me if it helps..*
Thanks & Regards,
Harmeet Singh
Sent via BlackBerry Wireless
On Mon, Sep 21, 2009 at 6:40 PM, Sonia Singla wrote:
> Hi
>
> I have the data in an array say in nXm. I want to make a macro color the
> cells with the same color having the same
Hi
I have the data in an array say in nXm. I want to make a macro color the
cells with the same color having the same next.
for example cells having 2 should have color red, cells having 5 should have
color blue etc.
Thanks
Sonia
--~--~-~--~~~---~--~~
---
Hi all, this is my first post! I have wanted to learn a bit of coding
for quite some time and the opportunity has finally presented itself
to do so; I am working on a small project for my employer which is
nothing more than a UserForm (with some TextBox and ComboBox controls)
to allow for a simple
Hi ashish
to do this first u select the data then click right button and go to format
cells.
Then select custom in number tab.
there type "dd/mm/"
Sonia
On Mon, Sep 21, 2009 at 6:19 PM, Sonia Singla wrote:
> Hi Ashish
>
> do you want a macro for this because this you can do by changing th
Hi Ashish
do you want a macro for this because this you can do by changing the format.
Sonia
On Mon, Sep 21, 2009 at 12:35 PM, ashish koul wrote:
>8/3/2009 8/3/2009 8/3/2009 8/4/2009 8/4/2009 8/4/2009 5/8/2009 5/8/2009
> 5/8/2009 5/8/2009 5/8/2009 5/8/2009
> THEY ARE IN DD MM
>
> I W
1-click on mouse right button then go to format cell then go to date format
then choose your option.
2- click on mouse right button then goto format cell then click on custom
then type mm dd .
On 9/21/09, ashish koul wrote:
>
>8/3/2009 8/3/2009 8/3/2009 8/4/2009 8/4/2009 8/4/2009 5/8/200
Check attached file and let me if it the same ur looking for
Thanks & Regards,
Harmeet Singh
Sent via BlackBerry Wireless
On Mon, Sep 21, 2009 at 12:35 PM, ashish koul wrote:
>8/3/2009 8/3/2009 8/3/2009 8/4/2009 8/4/2009 8/4/2009 5/8/2009
> 5/8/2009 5/8/2009 5/8/2009 5/8/200
Hi Ashish,
Query attached by you is solved now. Please find the attachment. Thanks.
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Mon, Sep 21, 2009 at 5:13 PM, ashish koul wrote:
> plz help and also day
Dear Umesh,
This is because, I am shifting your formula down to one row and then
inserting rows, which users inputs in the input box. So there will always
be one additional row.
Let me know if you want to remove this functionality. Thanks
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile:
Scratch my last post. Now it seems to be working.
Thanks anyway.
Doug
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free ad
I'm so annoyed at myself! I recorded a quick macro just to take a look
at the code it wrote and I named it "Format". Now Excel is not
recognizing it's own Format() function. How can I restore the original
function?
Thanks.
Doug
--~--~-~--~~~---~--~~
--
Hi Subu,
Automation is unlocked now and attached with this email. Thanks
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Mon, Sep 21, 2009 at 2:27 PM, Subu wrote:
>
> Hi
>
> Thanks for this automation, co
Hi,
Please find that attached spreadsheet. I have used converted the dates using
the 'Date Value' function and then used the day(),month() and year() formulas.
Thanks,
Amitabh
Date: Mon, 21 Sep 2009 07:43:44 -0400
Subject: $$Excel-Macros$$ hey also i was trying to convert these
plz help and also day, month function is not working in thsi file
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins
just attcahed a file for example
On Mon, Sep 21, 2009 at 6:46 AM, Aindril De wrote:
> Right Click on the cells
> Select Format Cell
> Under Number Tab
> Choose Custom in Category
> In the Type box type MM/DD/
> Click OK
>
> Regards,
> Andy
>
> On Mon, Sep 21, 2009 at 2:05 PM, ashish koul
Hi
Thanks for this automation, code
Is this code password protected ?
If so could you please give me the password or paste the VBA code
here ? so that I can use it in other sheets as well
TIA
regards
Subu
On Sep 11, 10:27 pm, Dilip Pandey wrote:
> Hi Subu,
>
> Attached workbook contains th
Right Click on the cells
Select Format Cell
Under Number Tab
Choose Custom in Category
In the Type box type MM/DD/
Click OK
Regards,
Andy
On Mon, Sep 21, 2009 at 2:05 PM, ashish koul wrote:
>8/3/2009 8/3/2009 8/3/2009 8/4/2009 8/4/2009 8/4/2009 5/8/2009 5/8/2009
> 5/8/2009 5/8/2009 5/8/
*Hi Ashish,*
Suppossing you have the data in column A, use following formula in column B
and drag it down.
=TEXT(A1,"mm/dd/")
or
=TEXT(A1,"mm dd ")
Best Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi -
8/3/2009 8/3/2009 8/3/2009 8/4/2009 8/4/2009 8/4/2009 5/8/2009 5/8/2009
5/8/2009 5/8/2009 5/8/2009 5/8/2009
THEY ARE IN DD MM
I WANT TO CONVERT THEM INTO
MM DD
regards
ashish
--~--~-~--~~~---~--~~
--
36 matches
Mail list logo
