Question on custom formating cell

E

excel_naive

Hi,
Is there a way to custom format cell?I mean when you select
column and right click on format cell you have an option to choose th
built in formats or custom format...but can we define our own forma
and include in the drop down of custom format?
 
F

Frank Kabel

Hi
Try putting the format in a blank workbook called Book1 and save this
in
your XLSTART folder
 
E

excel_naive

Hi Frank,
Thanks a lot for your reply but I am not quiet sur
how do I define my own format when I dont have the option to do so i
the custom format cell tab?
 
E

excel_naive

Hi Frank,
Thanks again for the reply but when I manually ente
something in a text box the whole column changes but what I am lookn
at is...
I need to have 3 values in a column i.e
if a user enters 1 the value should cahnge to Read-Only
2 - Assessor
3- reviewer

So I have the logic coded in a macro.Can I use the macro i
the custom format drop down so the users pick it when they need it??

Any help appreciated...
 
F

Frank Kabel

Hi
now you have lost me:)
- a format can be applied to a single cell (just select only one cell)
- if you currently use an event macro (sounds a little bit like this).
This can't be appended to the custom format dialog
- you may also take a look at
-> Data - Validatiuon
-> Format - Conditional format (though this won't allow locking
cells'

So in total I'm not so sure what you're really trying to achieve. A
custom format is just something like
[hh]:mm
or
DDDD DD/MM/YY

all entered in the Format - Cells dialog
 
E

excel_naive

Hi Frank,
I do have a event macro running that is doing thi
stuff...probably I would need to append this to custom format menu s
that I have this macro in that menu....
Hope you understood what I am looking for....Let me know i
you have any questions.....

Thanks a trillion for your time and patience..
 
E

excel_naive

Hi Frank,
What I(rather my manager) is basically looking for is
way to append a macro/proc to get the above functionality working t
format cell/conditional format or any other way other can directl
executing the macro.....Hope I was clear this time....


Thanks in advanc
 
F

Frank Kabel

Hi
you can't add a macro to this menu. sorry.
You have to put this event macro in every sheet you require this macro
for.
 
F

Frank Kabel

Hi
as said in my other post this can't de done (AFAIK) the way your
manager imagine it :)
- you could create a utton for invoking this
- you may also create an addin for this
- you can sue this macro as event procedure

You can't change or link this macro to the existing format menu in a
way that you could choose it like a normal date or number format. I
would like this kind of functionality but not possible. (AFAIK).

P.S.. I know how managers are but some things are just not feasible :)
P.P.S.: (sarcastic): he may ask Micrsofot to implement this for him
 
E

excel_naive

Hi Frank,
Thanks again buddy!!I wish the same way too...Bu
probably what he is looking for is attaining genric functionality i
the sense......In a event macro I have to specify the column I want t
change but is it possible to do it generically I mean not tying it t
one column or row and instead put the functionality in to work for an
column/row and let the user choose which column he wants that forma
in?Is it possible to do that?
This is what I currently have....So how I change it so that I nee
not specify target.column and make it generic......

Private Sub Worksheet_Change(ByVal Target As Range)
Debug.Print "RUNNING"
If Target.Column = 5 Then
Application.EnableEvents = False
Select Case Target.Value
Case 1
Target.Value = "Read Only"
Case 2
Target.Value = "Assessor"
Case 3
Target.Value = "Reviewer"
End Select
Application.EnableEvents = True
End If

End Su
 
F

Frank Kabel

Hi
see your other post. For your three conditions you could apply a custom
format without any macros
 
Top