Hi all
I am trying to make a sheet more user friendly so that people with less engineering experience can use it.
The sheet simply looks up an engineering part and auto loads the associated hours for its fitting and the part cost. That part works fine but there also needs to be some accompanying text that tells the engineer where this part is going, what it is being fitted to, etc. Experienced users can enter this data without looking it up in a technical manual. For example, they have enter the data like this
[Location] | [Fitting height] | [Orientation]
or like this
[Height] | [Weight] | [Distance from centre] | [Radius]
Those are just two examples and there many more.
Could I use a help balloon that would display these prompts when the user hovers their cursor over the part number? Better still would be active text that brought up an associated user form / script box that asked for the related parameters and then filled them in the sheet.
The balloon would be a good starting point.
Thanks in advance
Dave