G
Guest
I want to format a cell to show a Upper case X just by clicking on it.
Install the app
How to install the app on iOS
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
F
Frank Kabel
Hi
this would require VBA (using the Selectionchange event for example).
See:
http://www.cpearson.com/excel/events.htm
--
Regards
Frank Kabel
Frankfurt, Germany
this would require VBA (using the Selectionchange event for example).
See:
http://www.cpearson.com/excel/events.htm
--
Regards
Frank Kabel
Frankfurt, Germany
it.Lee and Rebecca said:I want to format a cell to show a Upper case X just by clicking on
G
Guest
Can you help me with this? I don't understand what to do from that web site.
G
Guest
Lee & Rebecca
Try this:
The first step is to get to the Visual Basic Editor. You can press Alt-F11
or use Tools, Macro, Visual Basic Editor.
You should see a screen with a bunch of stuff on it. In the upper left you
should see a window that says Project-VBA Project. In that window you should
see a list of the worksheets in your file. I'm not 100% sure the window will
have the title Project-VBA Project, but you must see that list of worksheets.
If you do not see this window, got to View, and click Project Explorer. Now
double click on the worksheet you want to work with.
This should make a window appear on the right, and at the top it will
probably have two boxes, one that says (General) and one that says
(Declarations). Click the one that says (General) and select Worksheet.
The box that said (Declarations) should now say SelectionChange, and there
will be a large window below those words. It may start with Option Explicit.
Next you'll see:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
End Sub
Between those two statements type the following:
Selection="X"
That should do it.
Art
Try this:
The first step is to get to the Visual Basic Editor. You can press Alt-F11
or use Tools, Macro, Visual Basic Editor.
You should see a screen with a bunch of stuff on it. In the upper left you
should see a window that says Project-VBA Project. In that window you should
see a list of the worksheets in your file. I'm not 100% sure the window will
have the title Project-VBA Project, but you must see that list of worksheets.
If you do not see this window, got to View, and click Project Explorer. Now
double click on the worksheet you want to work with.
This should make a window appear on the right, and at the top it will
probably have two boxes, one that says (General) and one that says
(Declarations). Click the one that says (General) and select Worksheet.
The box that said (Declarations) should now say SelectionChange, and there
will be a large window below those words. It may start with Option Explicit.
Next you'll see:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
End Sub
Between those two statements type the following:
Selection="X"
That should do it.
Art
N
Nick Hodge
Lee & Rebecca
This may help (download the file at the bottom of the sheet and read the
section on event code.
http://www.nickhodge.co.uk/vba/codeexamples.htm
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
This may help (download the file at the bottom of the sheet and read the
section on event code.
http://www.nickhodge.co.uk/vba/codeexamples.htm
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
G
Guest
Art, that worked however it puts "X" in every cell I click on. Can I make it
put an X in only selected cells?
put an X in only selected cells?
G
Guest
Art, that worked however it puts "X" in every cell I click on. Can I make it
No problem, except that depending upon what cells you want this to work for
it can get messy. You'll need an If Statement surrounding the original
statement you typed in.
Suppose that you want the X to appear if you click in a cell in columns C to
E, and for rows 4 to 6. You can do the following:
If target.column>=3 and target.column<=5 and _
target.row>=4 and target.row<=6 then
selection="X"
end if
Notice a few things. First, at the end of my first line there is a space
and an underscore. That's how you contnue the statement to the next line.
You don't have to do this, you can just string it out (probably up to 255
characters), but it usually makes for a more readable statement. If you do
do it, don't forget the space before the underscrore.
I indented selection="X" -- that's not necessary, but again improves
readability.
Finally, if you're conditions are much more complicated you can next the if
statements -- and if they're too complicated for that we can come up with
some other solution.
Art
put an X in only selected cells?
No problem, except that depending upon what cells you want this to work for
it can get messy. You'll need an If Statement surrounding the original
statement you typed in.
Suppose that you want the X to appear if you click in a cell in columns C to
E, and for rows 4 to 6. You can do the following:
If target.column>=3 and target.column<=5 and _
target.row>=4 and target.row<=6 then
selection="X"
end if
Notice a few things. First, at the end of my first line there is a space
and an underscore. That's how you contnue the statement to the next line.
You don't have to do this, you can just string it out (probably up to 255
characters), but it usually makes for a more readable statement. If you do
do it, don't forget the space before the underscrore.
I indented selection="X" -- that's not necessary, but again improves
readability.
Finally, if you're conditions are much more complicated you can next the if
statements -- and if they're too complicated for that we can come up with
some other solution.
Art
D
Dave Peterson
There's nothing that can be done just by clicking.
You could do it based on a doubleclick or rightclick -- but maybe this
alternative will work.
Select your range that should have this behavior (I'm gonna use column A).
Format|Cells|number tab|custom category
In the Type box, put this:
X;X;X;X
Now, anything you type in will look like an X (spacebar, x, Lee, anything!)
And if you want to find out if a cell is an X, you'll have to use something
like:
=if(a1="","nope","Yep")
(hitting the delete key on the keyboard will clear the cell)
Another alternative--if you want something that looks like a checkmark:
Format|Cells|number tab|custom category
In the "type:" box, put this:
alt-0252;alt-0252;alt-0252;alt-0252
But hit and hold the alt key while you're typing the 0252 from the numeric
keypad.
It should look something like this when you're done.
ü;ü;ü;ü
(umlaut over the lower case u separated by semicolons)
And format that range of cells as Wingdings.
All that other stuff still applies.
You could do it based on a doubleclick or rightclick -- but maybe this
alternative will work.
Select your range that should have this behavior (I'm gonna use column A).
Format|Cells|number tab|custom category
In the Type box, put this:
X;X;X;X
Now, anything you type in will look like an X (spacebar, x, Lee, anything!)
And if you want to find out if a cell is an X, you'll have to use something
like:
=if(a1="","nope","Yep")
(hitting the delete key on the keyboard will clear the cell)
Another alternative--if you want something that looks like a checkmark:
Format|Cells|number tab|custom category
In the "type:" box, put this:
alt-0252;alt-0252;alt-0252;alt-0252
But hit and hold the alt key while you're typing the 0252 from the numeric
keypad.
It should look something like this when you're done.
ü;ü;ü;ü
(umlaut over the lower case u separated by semicolons)
And format that range of cells as Wingdings.
All that other stuff still applies.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.