Is there any way to have a non zero value in a cell - say cell B5, popup a dialog box? Right clicking on a cell doesn't offer any event options which is what I'm really after.
I have a spreadsheet where we do data entry on quantities for various products. For any given item, as soon as the user enters a quantity other than 0 I'd like to put up a dialog box customized for that product to select options. i.e. user selects to get 3 widgets. The dialog box would ask for Widget color, shape, material, etc. I believe I can think of a way to have a neighboring cell monitor cell B5 and if its >0 to run a macro that will do the pop up, but I was hoping to avoid that ugliness. -- Bill Gradwohl --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
