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?

--
Message posted from http://www.ExcelForum.com

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

--
Regards
Frank Kabel
Frankfurt, Germany


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


---
Message posted from http://www.ExcelForum.com/

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?

--
Message posted from http://www.ExcelForum.com

Hi
just enter it manually in the textbox

--
Regards
Frank Kabel
Frankfurt, Germany


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


---
Message posted from http://www.ExcelForum.com/

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...

--
Message posted from http://www.ExcelForum.com

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


--
Regards
Frank Kabel
Frankfurt, Germany


Hi Frank,
Thanks again for the reply but when I manually enter
something in a text box the whole column changes but what I am lookng
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 in
the custom format drop down so the users pick it when they need it??

Any help appreciated....


---
Message posted from http://www.ExcelForum.com/

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..

--
Message posted from http://www.ExcelForum.com

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

--
Message posted from http://www.ExcelForum.com

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.

--
Regards
Frank Kabel
Frankfurt, Germany


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

Thanks a trillion for your time and patience...


---
Message posted from http://www.ExcelForum.com/

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




--
Regards
Frank Kabel
Frankfurt, Germany


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


Thanks in advance


---
Message posted from http://www.ExcelForum.com/

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

--
Message posted from http://www.ExcelForum.com

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

--
Regards
Frank Kabel
Frankfurt, Germany


Hi Frank,
Thanks again buddy!!I wish the same way too...But
probably what he is looking for is attaining genric functionality in
the sense......In a event macro I have to specify the column I want
to
change but is it possible to do it generically I mean not tying it to
one column or row and instead put the functionality in to work for
any
column/row and let the user choose which column he wants that format
in?Is it possible to do that?
This is what I currently have....So how I change it so that I need
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 Sub


---
Message posted from http://www.ExcelForum.com/