small excel forumla on taskbar or system tray?

[jasonbarrett]

Is there a good way to get a small formula to dock on the taskbar or system tray?

I do many many calculations using (A1) x (B1) = (C1) B1 is a fixed number. I would like to be able to click to my taskbar or system tray and have it run that number for me. I have to check dimension strings and this would be very helpful. Thank you!

 

[Joe4]

Using VBA, you can store formulas/procedure in macros or UDFs.

If you store it as a UDF, you can use like any other built-in Excel function.

If you store the procedure as a macro, you can attach it to a toolbar button and run that macro simply by clicking the button.

Where are the values coming from? If they are simply the values in cell A1 and B1, why not just enter the formula =A1*B1 in C1? Then anytime you change either A1 or B1, C1 will automatically change (as long as you have the Calculation mode set to automatic).

 

[jasonbarrett]

Interesting, I'll have to try that. I don't think I was clear enough though. I need this on my windows system bar, not the excel toolbar. I'm trying to do this so that one field (a1) is editable on the bar and excel is either not running or running in the background. I'm guessing that I'm probably asking to export it as something.

 

[Joe4]

Interesting, I'll have to try that. I don't think I was clear enough though. I need this on my windows system bar, not the excel toolbar

Well, you did post it in the Excel questions forum... :wink:

I will move this to the "Excel Discussion and other Questions" forum. I imagine you may be able to do something with Windows Scripting or VB Scripting, but I know very little about that.