Basically, the answer is No. You can write functions in VBA that you can call from worksheet cells, but these functions can only return a value. They can't modify other cells or alter any part of the Excel environment. (You may be able to use a worksheet change event to call the macro.)
How can I save a chart as a GIF file?
How can I print a workbooks full path in the header or footer? The Page Setup dialog box does not seem to offer the option.?
How can I enter the current date into a cell so it does not change from day to day? When I use the NOW function, it always shows the current date?
I need to determine the difference between two times. If the difference is positive, it works fine. But Excel does not want to display negative time values. Why not?
Is it possible to determine the day of the week for a particular date?
I have a range of time values, but when I try to sum them, the total is never greater than 24 hours?
I have a worksheet that shows total hours and minutes worked, along with the hourly pay rate. When I multiply these vales, I do not get the result I am looking for. What is wrong?
How can I calculate the difference between two dates?
How can I make text in a cell display in multiple lines?
I find that sometimes my formulas do not get fully calculated. This often happens when I use custom functions created with Visual Basic?
rendc.org
Whether it is technological solutions or user-oriented innovations, We have put together for you the best sources of HR Interview Questions and Answers, Tech Ideas, and Programming Tutorials."
Get all the latest information on rendc.org
© 2022 | All rights reserved.
RENDC
welcome to www.rendc.org
