Forum Discussion

JACK74's avatar
JACK74
Copper Contributor
Apr 24, 2020
Solved

DROPDOWN MENU

I try to create part number/description generator. So far I am able to create part numbers, but on the same time I would like to generate description using cells on other sheets. Please check attache...
Formulas and Functions
  • JACK74's avatar
    JACK74
    Apr 25, 2020

    Riny_van_Eekelen  thank you very much. This is what I was looking for :-). 

    One more thing, do you think it is possible to deactivate cell for point diameter when other than pencil is chosen from dropdown menu? Or, if is not possible to deactivate, can popup N/A in cell (for point diameter) when pen or marker is selected? Thank you again for your help.

JACK74's avatar
JACK74
Copper Contributor
Apr 25, 2020

Riny_van_Eekelen  thank you very much. This is what I was looking for :-). 

One more thing, do you think it is possible to deactivate cell for point diameter when other than pencil is chosen from dropdown menu? Or, if is not possible to deactivate, can popup N/A in cell (for point diameter) when pen or marker is selected? Thank you again for your help.

  • JACK74's avatar
    JACK74
    Copper Contributor
    Apr 27, 2020

    Riny_van_Eekelen thank you for your help. 🙂  For me this is black magic. LOL

Resources