|
|
|
Prevent cursor/focus from moving
Sat, 20 Mar 2010 13:42:11 -0700 (PDT)
Create a small Userform. Put two TextBoxes in it. Add the following
code.
Private Sub UserForm_Initialize()
TextBox1.Value = "0.00"
TextBox2.Value = "0.00"
End Sub
Private Sub TextBox1_KeyDown(ByVal KeyCode _
As MSForms.ReturnInteger, _
ByVal Shift As Integer)
...
|
Ribbon Customisation
Sat, 20 Mar 2010 19:41:17 -0000
Hi All,
I just wanted to know if its possible to to add custom controls to the
ribbon by using VBA alone? And what object reference to I need to add, to to
this?
Any help will be very much appreciated!
...
|
Extract last name from Last, First
Sat, 20 Mar 2010 11:42:01 -0700
I know this has to be a common question, but I can't find the answer...
Using VBA, I need to extract the last name from the format:
Last, First
For example:
the cell contents extract to a variable the value of
JONES, AMY JONES
ADAMS, HARRY ...
|
Build a String Sort Key, sort a 2 dimen array Mar20
Sat, 20 Mar 2010 10:38:01 -0700
Hi All, Mar20
I'm building a utility function that sorts the rows of a 2 dimen
array on any up to all of its columns, (ascending or descending by wanted
column.) My 'first' version is working fine.
I'm enhancing the first version which handled only positive integer
and long da ...
|
odbc connection lost
Sat, 20 Mar 2010 10:32:01 -0700
while reading excel file I am getting the following error
[Microsoft][ODBC Excel Driver] The connection for viewing your linked
Microsoft Excel worksheet was lost
--
Trioum ...
|
Combined Cell Value
Sat, 20 Mar 2010 10:19:01 -0700
Hi All,
I have list in following format:
A B C D E
0 1 2 3 4
Results wanted:
F
"0","1","2","3","4"
One more question is it possible to merge multiple column values into one
column without lost the values?
Thanks in advance. ...
|
Time duration calculation
Sat, 20 Mar 2010 08:37:01 -0700
Hi Team,
A B
C
REPORTEDDATETIME STATUSDATE Result (HH:MM)
03/16/2009 07:00 AM 03/16/2010 07:00 AM 8760:00
02/16/2010 04:00 AM 02/16/2010 07:00 PM ...
|
|
|
copy a hyperlink to another cell
Sat, 20 Mar 2010 14:40:49 +0000
Hi friends,
Now i am tried for long time to copy the hyperlinks from a cells to
another cells (column beside column) but without good results :) would
you help me please?
thank you very much
--
aya2002
------------------------------------------------------------------------
aya2002's Profile: 1625
...
|
Letters in the code
Sat, 20 Mar 2010 05:35:01 -0700
Hi All, i am trying to figure out how to modify the code but i cam accross a
few letter i don't know what they are. can you please help me to determine
what these letters are in the below code:
Letter: e, a1, a, b1, b, c1, c, m, rr, rrbc, x
-------Beginning of Code--------------
Private Sub RR_Calculation ...
|
How to code it on macro ?
Sat, 20 Mar 2010 04:04:01 -0700
Does anyone have any suggestions on how to code it on macro?
I would like to add mroe coding for this master.xls file
1) opening file1.xls
2) refreshing all from external links within file1.xls
3) close file1.xls
4) open file2.xls
5) running specific macro under this worksheet, which will be closed
automati ...
|
|
|
