Dear visitor, welcome to Palo Community Forum.
If this is your first visit here, please read the Help. It explains in detail how this page works.
To use all features of this page, you should consider registering.
Please use the registration form, to register here or read more information about the registration process.
If you are already registered, please login here.
Excel Dropdown
Hi
I sometimes need to restrict the user to fill only specified Data into one field. As I have read, this is supposed to work with the normal Excel Dropdown function.
Is does - sometimes. And that's the problem. Because sometimes excel just feels like overwriting the PALO-formula with the selected input. Very often the user doesn't even notice he hasn't written into PALO and has demolished the input-form.
Does anyone have suggestions on how to use a Dropdown-List and make sure, the PALO-formula isn't overwritten?
Thanks
brgds
RE: Excel Dropdown
What Palo formula do you use?
Usually the usage of backspace and delete key kill your formula.
regards.
Usally DATA or DATAC
And the formula is not deleted because I press any key - it is deleted sometimes (not everytime) I select an item of a dropdown-list by clicking it with the mouse.
When you are using the dropdown and want to view data accordingly then you have to place the value from dropdown on filter data.
boost,
this is a general problem how addins work with Excel.
If you want to play it safe you should use SETDATA and reference an input field.
In the referenced cell your users can delete, c&p or use drop downs.
The question then is: do you hide the SETDATA formula(s). Do you error check the inputs?
You lost me... somewhere on the way...
I know about SETDATA - But otherwise I do not understand what you both suggest (seems to be the same though?)
please give further information.
Thanks
I know that thread. But thanks anyway.
It is indeed quite a solution - but not stupid-user-save... I really hate answering questions on the phone with "Please press F9"
But if that is the only way I mights have to deal with that.
Thanks @all
Hi,
well, you could place a "Save" Button that executes the calculation. Should be quite "stupid-user-save". In addition you could color the caption of the button red, everytime the sheet is changed. Means -> red "Save" caption -> User got to save. User saved it -> caption is green.....or something like this.
Holger
