why dont you hide buttons on click and unhide on another
On Monday, November 17, 2014 4:10:26 PM UTC+5:30, Rupesh Patil wrote:
>
> Hello experts,
>
> I need your help,I have one userform which attached with mail for your
> reference, what I need is add text boxes vertical on button every time
Hello Expert,
No one has solution, that is ok, at least give me some hint so that I can
do it my own.
On Thu, Nov 20, 2014 at 7:26 PM, Paul Schreiner
wrote:
> OK, I'll take a look at this as soon as I get some things I'm PAID to do
> taken care of!
>
>
> *Paul*
> ---
Where can I find a list of all methods and functions for VBA in Excel. I
want it in readable format not while searching with the object explorer.
various website is showing but not a complete information in single link.
Regards,
Mandeep Baluja
Excel Specialist.
https://www.linkedin.com/profile
Could you double-check your calculation again?
in your sample, transction #6 (12:30-14:30) is completely contained within
transaction #5 (12:00-16:00)
so would not contribute to the total.
my calculation comes up with 5:50 instead of 6:20
Paul
-
“Do all th
hey
welcome, keep sharing your knowledge!
Fijne Avond!
+
*I did not do this for you. God is here working through me for you.*
On Wed, Nov 26, 2014 at 4:47 PM, Muneera Shabana
wrote:
> Hello buddies,
>
> This is Muneera Khan from Amsterdam, the Netherlands Currently working
> as Busine
Sub XLS_to_CSV()
Dim wb As Workbook
Dim strFile As String, strDir As String
SourcePath = "C:\Users\pc\Desktop\45.November.2014\"
strFile = Dir(SourcePath & "*.xlsx")
Do While strFile <> ""
Set wb = Workbooks.Open(Filename:=SourcePath & strFile, Local:=True)
newpath = "C:\Users
Sub CSV_to_XLS()
Dim wb As Workbook
Dim strFile As String, strDir As String
SourcePath = "C:\Users\pc\Desktop\45.November.2014\"
strFile = Dir(SourcePath & "*.xlsx")
Do While strFile <> ""
Set wb = Workbooks.Open(Filename:=SourcePath & strFile, Local:=True)
newpath = "C:\Users
Dear,
we are not concerned about it.
Thank u for your solution
.
Enjoy
Team XLS
On Wed, Nov 26, 2014 at 4:16 PM, Mandeep Baluja
wrote:
> No I don't want to check you knowledge. I had given the solution to share
> knowledge. As far your team is concerned you are far b
Hello buddies,
This is Muneera Khan from Amsterdam, the Netherlands Currently working
as Business Process Analyst for Market Risk Management at ING Bank.
I love museums, travelling, painting, arts & fashion!
I highly appreciate all the contributers here providing very good
supportAn
Good Morning,
Hope you are having a great day!
*Objective: I want to convert all the excel files (.xls,.xlsx etc) in a
folder to .csv files (with original file names) & place the csv file in
another target folder.*
I am not an excel expert, however I managed to write the below piece of
cod
No I don't want to check you knowledge. I had given the solution to share
knowledge. As far your team is concerned you are far better than me.
On Wednesday, November 26, 2014 4:07:51 PM UTC+5:30, XLS S wrote:
>
> is this your question for help...do you want to check our knowledge?
>
>
is this your question for help...do you want to check our knowledge?
.
Enjoy
Team XLS
On Wed, Nov 26, 2014 at 4:02 PM, Mandeep Baluja
wrote:
> build this hope this help someone else.
>
> Sub Format_to_time()
>
> Selection.NumberFormat = "[h]:mm:ss"
> Selection.Font.Bol
build this hope this help someone else.
Sub Format_to_time()
Selection.NumberFormat = "[h]:mm:ss"
Selection.Font.Bold = True
End Sub
On Wednesday, November 26, 2014 3:29:40 PM UTC+5:30, Mandeep Baluja wrote:
>
> [h]:mm:ss
>
> What is the keyboard shortcut to set the time in this format.
>
--
Sorry, in excel there is no shortcut related specify format...
you can use ctrl+shift+@ for general time format
.
Enjoy
Team XLS
On Wed, Nov 26, 2014 at 3:29 PM, Mandeep Baluja
wrote:
> [h]:mm:ss
>
> What is the keyboard shortcut to set the time in this format.
>
> --
[h]:mm:ss
What is the keyboard shortcut to set the time in this format.
--
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 @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate t
Dear Ganesh
Thank for your advise but i found out there are some mistake in your
formula.Please you refer enclosed file and I hope you might give new
solution.
Son
2014-11-26 13:26 GMT+07:00 Ganesh N :
> Dear son nguyen,
>
> PFA
>
> Regards,
> Ganesh N
>
> On Wed, Nov 26, 2014 at 10:03 AM, Gane
16 matches
Mail list logo