You can only place the radio button captions to the left or right of the
option indicator. The Alignment property does that.
When you have placed the labels (with caption) above the option button, you
can use some code like -
Private Sub OptionButton1_Enter()
Label2.BorderStyle =
Dear All,
Is there any option that when I select a cell in the sheet, the whole row
corresponding to that cell is highlighted.
In the attached example I have selected cell C7. Required: the whole row 7
should be highligted.
Thanks and regards,
Sheyn
Hi All,
Can any one tell me the formula to get the value as in Required answer as
against Original Value.
*Original Value*
*Required answer*
125756.95-
-125756.95
75845.25-
-75845.25
123.38-
-123.38
10.15-
-10.15
158946-
-158946.00
856456.25-
-856456.25
Regards- Putta Madaiah-
Hi,
Try this formula in B2, and copy down.
=LEFT(A2,LEN(A2)-1)*-1
You will have to format the cell to Number, 2 decimal places.
Regards - Dave.
Date: Tue, 4 Aug 2009 14:38:34 +0530
Subject: $$Excel-Macros$$ Formula-Replacing Minus Symbol
From: puttamada...@gmail.com
To:
Remember that Excel stores numbers as numbers.
it may DISPLAY them in all variety of things.
For instance, the number 109.123456
Could be SHOWN as:
109.123456
109.12
109.1234560
4/18/1900
2:57:47 AM
4/18/00 2:57 AM
the letter m
Each of these LOOK different, but are actually the same
I don't know that there is any OPTION for this, but
I have done it before with a MACRO.
but there are a few tricks
I use the Worksheet_SelectionChange event.
First, record a macro in which you clear all formatting (highlighting)
then highlight the row you wish to highlight.
this will get you
THanks Dave, this is working fine for me..
Rgds- Putta
On Tue, Aug 4, 2009 at 5:09 PM, Dave Bonallack davebonall...@hotmail.comwrote:
Hi,
Try this formula in B2, and copy down.
=LEFT(A2,LEN(A2)-1)*-1
You will have to format the cell to Number, 2 decimal places.
Regards - Dave.
Hello,
You can use the following formual to achieve the required:
=-MID(B26,1,FIND(-,B26)-1)
The formula will add a - sign infront of the number extracted from original
value cell with suffixed - omitted.
Kind regards.
Serghei.
Date: Tue, 4 Aug 2009 14:38:34
Hi Puttam,
Same can be done with ASAP Utilities.
Text--Reverse text in selceted cell.
Hope this will saolve ur problem.
Rgds,
Mahender Bisht
On Tue, Aug 4, 2009 at 2:38 PM, Putta Madaiah puttamada...@gmail.comwrote:
Hi All,
Can any one tell me the formula to get the value as in Required
That worked beautifully! Thanks!
What if I wanted it to populate a named range? Is that possible.
On Aug 3, 1:18 am, msakibkhan msakibk...@gmail.com wrote:
Dear Jake !
try the following solution:
Private Sub cmdOK_Click()
Sheet2.Range(A4:A1000).ClearContents
For x = 0 To
Hi,
I have to delete so many cell entries in my daily job and input those
cell entries in the comments with some text. Any shortcut for the same
would be helpful ...
Rg
--~--~-~--~~~---~--~~
I'm not sure if this is what you want...
Example:
=The amount in cell A1 is A1 and this will change daily.
On Tue, Aug 4, 2009 at 11:48 AM, Jaspal Rehal rehal.jas...@gmail.comwrote:
Hi,
I have to delete so many cell entries in my daily job and input those
cell entries in the comments
I need to retrieve stock information from a web site. (It can be any
site that provides such information - the site is not important). I
need to retrieve this information at set intervals - e.g., every 10
minutes, and record in Excel (a) the time of retrieval (b) the stock
quote (c) any other
Problem:
I want to calculate currency difference for yrs 1997-2007. Currently
this is done via:
Sheet9! below
a b c
1DateAUSUSA
2 199712 0.782 1
3 199801 0.761 1
.
.
.
n 200712
Hello all,
I'm attempting to have a window pop up when the user clicks a
command button on the sheet. The hurdle I have come to is drawing on
the form. I have dimensions on the sheet that I want to feed into the
pop-up for this sketch.
What am I missing? I can't get any shape commands to
thnx for prompt reply
PFA an example of what I am looking for ...
Rg
On Tue, Aug 4, 2009 at 9:42 PM, Norman Maynor...@gmail.com wrote:
I'm not sure if this is what you want...
Example:
=The amount in cell A1 is A1 and this will change daily.
On Tue, Aug 4, 2009 at 11:48 AM, Jaspal Rehal
Hi Putta,
Try -
= substitute([cell ref],-,)*(-1)
Thanks
Alvin
On Aug 4, 5:08 pm, Putta Madaiah puttamada...@gmail.com wrote:
Hi All,
Can any one tell me the formula to get the value as in Required answer as
against Original Value.
*Original Value*
*Required answer*
125756.95-
17 matches
Mail list logo