Function to adjust font properties

[SoothSailor]

I'm not very good at writing functions, and I'm wondering if there's a way to create a function to change font size, among other things. It would look something like this:

Please Login or Register  to view this content.

Or to adjust fint, color, and size, it would be like this:

Please Login or Register  to view this content.

I only know how I would write it into a formula, and how to record it as a macro, but I can't actually write it as VBA.

Thanks!

[Jockney]

for the active cell you can use

Please Login or Register  to view this content.

(What ever size you want)

Please Login or Register  to view this content.

Hope this helps. If you need anything else please let me know

[MrShorty]

A User-defined function (a VBA function procedure called from a spreadsheet cell) cannot change cell properties such as font type, color, or size. If I understand what you are asking for, I don't think you can do it in the way you are proposing.

Conditional formatting can probably do this, and you can conceivably use a UDF as part of determining the conditions for formatting. Event code (calculation or change event, most likely) could also do this. If you can explain in more detail what you are hoping to accomplish here, we can help you put something together.

[SoothSailor]

Thank you, but I want to be able to incorporate it into formulas, for example:

Please Login or Register  to view this content.

And I know I can probably do this through conditional formatting, but I don't to create a new rule for every circumstance that I'd need it for.

[MrShorty]

Font face, size, and color are all properties of a cell -- not part of the cell's value. A UDF called from a spreadsheet cell like you are proposing cannot change the properties of a cell (even the cell it is called from).

I'm not sure what to suggest. Conditional formatting is obviously out. You can apply limited formatting (colors) based on conditions using number format codes (see examples here: http://office.microsoft.com/en-us/ex...372.aspx?CTT=1 ). The most flexible will be to use a Sub procedure (probably associated with appropriate events like the change and calculate event).

[SoothSailor]

Ah, I see. If it's not meant to be, it's not meant to be. Thanks!