Hi, Everyone,
I need to add a menu that the user can type his entries in it to make the calculation for no user error.
I have a cell for Telecommunication(that will be the to total) of Phone +TV + Internet + Cell + Long Distance cost.
It should be a sub menu like a popup and the user can put his entries and the total register in the cell Telecommunication.
Is it possible, maybe with VBA, but I preferred not…
Thanks for your help
Or you insert a “List box” control and link it to a cell. Such control will work even if the sheet is protected. But creating it is more complex than the list of the validity check.
It seems that you didn’t understand my case.
I want: when the user click on telecom filed, a submenu appears with tv, internet etc. inside and the user type his payment inside.
And the total appears in telecom field.
Is ti possible?
I thought the user selects items. Why do you need a submenu?
No, such is not directly possible. You will need to use a macro to provide a submenu.
It is what I want, sorry.
If it is too hard, I’m going to let it happen.