Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Get current cell with VBA function
I've written a VBA function that will be used on a worksheet as a worksheet
function. I want to modify the formatting of the cell that the function is in. I haven't found any way that works. How do you reference the cell that the formula is in and make changes to it? Thanks, -phil -- no place like 127.0.0.1 |
#2
|
|||
|
|||
maybe
activecell. format(activecell,"yourformathere") -- Don Guillett SalesAid Software "vbphil" wrote in message ... I've written a VBA function that will be used on a worksheet as a worksheet function. I want to modify the formatting of the cell that the function is in. I haven't found any way that works. How do you reference the cell that the formula is in and make changes to it? Thanks, -phil -- no place like 127.0.0.1 |
#3
|
|||
|
|||
ActiveCell doesn't compute in a function called from a worksheet formula. It
only works from within a VBA macro call. |
#4
|
|||
|
|||
Perhaps you should post your udf and telll us exactly what you want to do
-- Don Guillett SalesAid Software "vbphil" wrote in message ... I've written a VBA function that will be used on a worksheet as a worksheet function. I want to modify the formatting of the cell that the function is in. I haven't found any way that works. How do you reference the cell that the formula is in and make changes to it? Thanks, -phil -- no place like 127.0.0.1 |
#5
|
|||
|
|||
Functions, including User Defined Functions, cannot change the
formatting of a cell. To do that you'd need an event macro in the worksheet or workbook code module, e.g., Worksheet_Change, or Worksheet_Calculate. If you post what you're trying to do, it would be easier to suggest a solution. In article , vbphil wrote: I've written a VBA function that will be used on a worksheet as a worksheet function. I want to modify the formatting of the cell that the function is in. I haven't found any way that works. How do you reference the cell that the formula is in and make changes to it? |
#6
|
|||
|
|||
You have answered the basis of my question. It can't be done this way.
Here's a greatly simplified example. I just wanted to know if you can access the range object or cell of where the formula is entered besides just settings it value. 'the worksheet cell formula would be "=setFormat()" function setFormat() as string 'set the font of this cell to bold or set the color ....... 'set the cell value setFormat = "test" end function Thanks for the feedback, -phi "JE McGimpsey" wrote: Functions, including User Defined Functions, cannot change the formatting of a cell. To do that you'd need an event macro in the worksheet or workbook code module, e.g., Worksheet_Change, or Worksheet_Calculate. If you post what you're trying to do, it would be easier to suggest a solution. In article , vbphil wrote: I've written a VBA function that will be used on a worksheet as a worksheet function. I want to modify the formatting of the cell that the function is in. I haven't found any way that works. How do you reference the cell that the formula is in and make changes to it? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i insert the current time into a cell, and show different . | Excel Discussion (Misc queries) | |||
Current Cell Color | Excel Worksheet Functions | |||
Is there a function to determine whether a cell contains a formul. | Excel Worksheet Functions | |||
Excel - option to extend function in cell to column | Excel Worksheet Functions | |||
Finding last cell to contain same value as current cell? | Excel Worksheet Functions |