Hi All,
I have a user form wherein I set the variable of a global variable
based on the selection of certain radio buttons. Based on the value
chosen I have command buttons selected and deselected in the
worksheet.
But after I hide the form and activate the sheet, the control is not
transferred
You can use text to colum option to convert to date formate
select colum
data-text to column
select fixed width
select Date from column data format
Finish
Now your data will be converted to date format
Thanks
Udhay
On Mon, Jul 20, 2009 at 9:44 PM, Manoj Kukrej manoj...@ocimumbio.comwrote:
Hello,
Plse tell how to work
Pls tell me step
Thanks in advance
On Tue, Jul 21, 2009 at 10:55 AM, Pranaya Pradhan pradhan.pran...@gmail.com
wrote:
TRY THIS ONE
Function SpellNumber(ByVal MyNumber, Optional incRupees As Boolean = True)
Dim Crores, Lakhs, Rupees, Paise, Temp
Dim
hi sandeep...
pls check the files of the group... there are many books and useful
material...
if still not satisfied... write back... will arrange for something else
all the best
Regards,
Vivek Agrawal
Skype ID - vivek.agrawal83
GoogleMoonlight.com - Saving energy-Save Earth
2009/7/15
Hi Friends,
A small query in pivot table i want convert vertical text of in horizontal.
in attached data sheet =main data
like this sheet=after pivot table (Result)
Please cheek the attached file.
Regards
Amresh
--~--~-~--~~~---~--~~
Hi Ruchi,
Attached is the solution.
I am presuming that the data in the yellow cell is extracted with the time
inputted in the adjacent cell.
Please let me know if you have any questions.
Thanks Regards
Ankit Mehra
On 7/20/09, Ruchi Saxena ruchi.saxe...@gmail.com wrote:
Hi friends,
i m
Dear Shafiq:
I can give you my own built billing softwre (free) in MS Access. If you
require that then you have to send the data (i.e.Fields of your billing).
And accordingly I will build it for u.
Thanks
Daniel
On 7/6/09, shafiq online shafiq_onl...@hotmail.com wrote:
Hi,
Can anyone has
Hi
One solution is to control the axis on the graph.
This can be done a simple Macro.
ActiveSheet.ChartObjects(Chart 1).Activate
ActiveChart.Axes(xlValue).Select
With ActiveChart.Axes(xlValue)
.MinimumScale = Range(AA75).Value
.MaximumScale = Range(AA76).Value
Hi Dev,
Your macro is more complex than necessary.
You don't have to unhide sheets, or select ranges to work on them.
The following 2 lines of code should do what you need.
Sub DoWhatDevNeeds()
Sheets(Dump).Cells.ClearContents
Sheets(Formula).Columns(A:B).ClearContents
End Sub
Hope this
Thank u so much vivek for writeing me ..i have scarch e book and helping
material but i did not find can u plz send me link of those file i will
really appreciate u for this help .
Regards: ╚►♥ѕαη∂єєρ♥◄╝
On Tue, Jul 21, 2009 at 12:14 PM, vivek agrawal
vivek.agrawa...@gmail.comwrote:
hi
Hey Ruchi i have attached soluction, see this one u requrired or something
eals .
Regards: ╚►♥ѕαη∂єєρ♥◄╝
On Mon, Jul 20, 2009 at 11:44 PM, Ruchi Saxena ruchi.saxe...@gmail.comwrote:
Hi friends,
i m new to this group...
Can somebody help me with the attached sheet
Regards,
Ruchi
Hi
Thanks a lot to Ankit, Shreyans, Mahesh
but any other time entered say 5:16 does not give me answer (the attached
sheet says that till 5:15 it is L but from 5:16 to 5:30 it is O so on)
so when i enter 5:16, it must give status as O
Can you please refine such that any time entered will give
Hello Dustin
You can also add the following one line code as the first line of code just
below Sub.
Application.ScreenUpdating = False
this would not update the screen and would look as if the task has been done
in a flash of light.
Regards,
Vivek
Well Ruchi,
For that, edit the Vlookup function entered... just replace the last
argument passed from 0 to 1)
hope it helps
Thanks
Regards,
Vivek Agrawal
Skype ID - vivek.agrawal83
GoogleMoonlight.com - Saving energy-Save Earth
On Tue, Jul 21, 2009 at 3:42 PM, Ruchi Saxena
Thanks a lot vivek !! it is really helpful for me ..if u have or this type
of file to learn functions plz send me likn or file ..
and again thank u so much fnd
Regards: ╚►♥ѕαη∂єєρ♥◄╝
On Tue, Jul 21, 2009 at 4:00 PM, vivek agrawal vivek.agrawa...@gmail.comwrote:
Hi Sandeep
open this
Welcome Sandeep...
just be in constant touch with the FILES section of our group... you would
get relevant material from there...
Thanks and Regards,
Vivek Agrawal
Skype ID - vivek.agrawal83
GoogleMoonlight.com - Saving energy-Save Earth
2009/7/21 ╚►♥ѕαη∂єєρ♥◄╝ jackjho...@gmail.com
Thanks
hi
your query doesnt seem to be clear can u please mail the worksheet
and clearly state what do you actually want
Thanks
On Jul 17, 12:21 am, osiso fahe...@gmail.com wrote:
Guys,
I am not well versed in vba, more just excel functions. So I recorded
a macro where I typed in the if then
Dear Daniel
Can you please send a copy at the below given ID
rashid.imt...@gmail.com
i will pay you. if i got any customer for sure.
I just want to get things going
regards
rashid
On Tue, Jul 21, 2009 at 4:26 PM, Hitesh Taunkhitesh.ta...@gmail.com wrote:
Hello Everyone,
Dear Daniel.
Thank you for your reply. I am working in a small restaurant. I just want to
print computerized invoices and to record the sales data. In this regard I need
a point of sales type of software. Now you can assume fields better then mine
as I have not in depth konwledge of
Hello Rajesh
For this you would require to send the following excel files so that
the format and the structure can be used...
1. The report which you download from SAP
2. the format in which you want the PL, Cash Flow and the Balance
sheet..
Thanks
On Jul 16, 7:42 pm, Rajesh Janardanan
hello
your question doesnt seem to very clear. can u pls post an excel file
with clearly depicting what u exactly want
thanks
On Jul 16, 8:09 pm, osiso fahe...@gmail.com wrote:
to basically help with proramming in vb excel to do things such as:
1. create if then statement where the
Hello.
Try :
=TODAY()-INDEX({2,3,1,1,1,1,1},WEEKDAY(TODAY()))
Daniel
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-
mac...@googlegroups.com] On Behalf Of totalnatal
Sent: mardi 21 juillet 2009 13:35
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Get
Hi Jonathan,
Use the following formula:
=IF(OR(WEEKDAY(TODAY(),2)=2,WEEKDAY(TODAY(),2)=3,WEEKDAY(TODAY(),2)=4,WEEKDAY(TODAY(),2)=5,WEEKDAY(TODAY(),2)=6,WEEKDAY(TODAY(),2)=7),TODAY()-1,TODAY()-2)
Please let me know if this helps.
Regards,
Andy
On Tue, Jul 21, 2009 at 6:35 PM, totalnatal
HI,
In cell G4 (or elsewhere, maybe hidden), enter :
=Revenue (G2)
Select the chart title and, in the formula bar, enter :
=G4
Hope this helps.
Daniel
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of gyanesh jain
Sent: mardi 21 juillet 2009 14:32
hello,
I was successfully using the following code as entering orders to
trade commodity futures in to exchange.
Private Sub Worksheet_Calculate()
Const WS_RANGE As String = B1 '== change to suit
On Error GoTo ws_exit
If Range(WS_RANGE).Value = oldval Then Exit Sub 'value has not changed
oldval
Kamal,
Can you please forward the formula for standard exchange rate..thx
On Jul 19, 4:04 pm, kamal shah kamal...@gmail.com wrote:
Are you looking for standard Exchange Rate or a variable?
If so then u dont need macro for it. you can get it done with simple
formula..
let me know if u need
are you there???
On Jul 20, 10:58 pm, Lynn moley_c...@yahoo.com.au wrote:
could you teach me how you came up with this formula?
thanks
On Jul 20, 1:40 pm, Ashish Pradhan ashlyprad...@gmail.com wrote:
Hello Lynn
In Conditional Formatting, you can use the formula (Please select the
Regards,
Vivek Agrawal
Skype ID - vivek.agrawal83
GoogleMoonlight.com - Saving energy-Save Earth
On Tue, Jul 21, 2009 at 7:21 PM, Rajesh Janardanan rajesh...@gmail.comwrote:
Thanks Vivek.
But what are the tools or formulas in excel we can use for doing this
package ? I would like to try
Trick to get serial number behind Date format
Select a cell and enter today date into the cell by pressing Ctrl+;
than press Ctrl+~.
Press Ctrl+~ again to restore the sheet to its normal appearance.
thx
On Jul 21, 11:18 am, Ayush jainayus...@gmail.com wrote:
Dear Members,
Let us begin week
Well Rajesh
I do not think there is a specific formula...
its just that i would create a vba application which would transfer the
entries from the trial balance to the respective target reports...
Regards,
Vivek Agrawal
Skype ID - vivek.agrawal83
GoogleMoonlight.com - Saving energy-Save Earth
Sorry, I missed this one. Calendar control is not shipped with every brand
of Office. It is usually shipped with MS Access. You can find on the
internet or use the Microsoft date and time picker control instead.
Hope this helps.
Daniel
-Original Message-
From:
Have you tried setting a breakpoint and see if
what it is actually doing by stepping through the code?
and.. what do you mean that it stopped recognizing range 3 and 4?
What are the values you're testing?
B1 =
B2 =
B3 =
B4 =
Paul
From: TAlgo
Hello MartyH,
I was able to do this by installing NcFTP on my computer. It is
available here: http://www.ncftp.com/download/. You want to install
the client (not server.)
Once you install that program, modify the following code to accomplish
saving to an FTP file:
Sub SaveTXT2FTP()
'
'
Name: Justo Morales
Subject: Data Summary
Detail: Sometimes you need to get a summary of many different values.
However, you may not be sure what fields you have listed. For
example, say you have the total number of colors produced by day for
an entire month. You want to know exactly how many
I'd love to, but for whatever reason I can't see your email address
and can't attached a sample workbook in this post
On Jul 21, 8:33 am, Daniel dcolarde...@free.fr wrote:
Can you mail back a sample file ?
Regards.
Daniel
--~--~-~--~~~---~--~~
Yes, once I close the source workbook, the filepath isn't added
automatically and I get a REF error.
On Jul 21, 8:48 am, Luke Mercer lukeatmer...@googlemail.com wrote:
Do you mean that the 'links' funciotnality is not updating the directory and
path of the model when the link is via a
Hello all,
I was wondering if anyone could tell me why, when I Duplicate a Shape
(image), I can't assign OnAction property to it. Following is a simple
code that gives me Run-time error 1004: Application-defined or object-
defined error:
Sub Image1_Click()
Dim new_shape As Excel.Shape
Hi Ruchi,
Enter the below formula in the cell C2
=VLOOKUP(TIME(HOUR(B2),CEILING(MINUTE(B2),15),0),$F$2:$G$99,2,0).
Regards,
Upendra Singh
+91-9910227325, +91-9310760597
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Ruchi Saxena
Hi Ruchi,
Gud Morning,
Hope ur query is solved now.
With Love
Mahesh...
On Tue, Jul 21, 2009 at 5:38 PM, Anil Kumar Agarwala
akagarw...@gmail.comwrote:
Hi Ruchi,
Why don’t you try with 1 in the vlookup instead of 0 thus
=VLOOKUP(B2,F3:G99,2,1)
I believe you will get the desired
B1 = last traded price of crude oil futures ( get through DDE link so
keeps changing every sec ) e.g. 6500
B2 B3 ( I define the range so if B1 goes between the value specified
in B2 and B3 then run another macro ( Call BuyBeansSellProducts )
which will enter multiple Buy Orders in to exchange)
Alright..i tried on another laptop and it works perfect..just its not
working on my work computer..any ideas?
On Jul 21, 1:26 pm, Paul Schreiner schreiner_p...@att.net wrote:
Have you tried setting a breakpoint and see if
what it is actually doing by stepping through the code?
and.. what do
Instead of trying to fix this problem, could anyone tell me how I
could make multiple images execute the same code but with a different
parameter upon clicking?
--~--~-~--~~~---~--~~
Hi Daniel,
If i click CHART TITLE, formula bar not comes. it is just a text box,
so how to write formula in Chart Title?
U can try in the attachment.
On Tue, Jul 21, 2009 at 8:19 PM, Daniel dcolarde...@free.fr wrote:
HI,
In cell G4 (or elsewhere, maybe hidden), enter :
=Revenue (G2)
Hello,
According to me, the error is because of the mismatch of object type and not
that you are not able to assign onaction property to a shape object.
The new_shape is of Excel.*Shape* type where as you are assigning to the
new_shape - the duplicate of an Excel.*Shapes *type. While, SHAPE
Can u please mail a sample excel sheet to make your doubt somewhat more
clear.
Thanks and Regards,Vivek Agrawal
Skype ID - vivek.agrawal83
GoogleMoonlight.com - Saving energy-Save Earth
On Tue, Jul 21, 2009 at 11:54 PM, Aamir Shahzad aamir...@gmail.com wrote:
Dear all,
Can anyone tell
Hi.. I cant able to understand the question.. also I ve not received any
attachment.. Pls mention the question clearly...
--
Best Regards
Anish
--~--~-~--~~~---~--~~
--
Some
Hello Bro/Sis
Pls How to learn Vbs Macros pls send me link how to learn
Thanks My Big B/S
Nandkumar
On Wed, Jul 22, 2009 at 10:16 AM, vivek agrawal
vivek.agrawa...@gmail.comwrote:
Hello,
According to me, the error is because of the mismatch of object type and
not that you are not able to
Hello Excel Experts and Learners,
I have uploaded a torrent file which contains N number of books
related to Microsoft Office 2007. They are indeed very helpful. I have
downloaded all of them and they seem to include all the GOOD books
present on this earth for learners of Office 2007. FYI -
Hello NandKumar
Please scan through the recent posts and files on this group. You would find
links and reference to books for learning VBA.
Thanks and Regards,
Vivek Agrawal
Skype ID - vivek.agrawal83
GoogleMoonlight.com - Saving energy-Save Earth
On Wed, Jul 22, 2009 at 10:26 AM,
49 matches
Mail list logo