Autopop info choices

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Newbie here.
I would like to add an autopopulation script when activated to present
options with checkboxes or the like, for comments and to create a final
comment from the options selected for pasting.

Example.
When i click the button "Custom Comments", a list of selections popup and
populates in a checkbox or soemthing, floating like a toolbar maybe.

Selections are and not limited to: Black, white, blue, red, shoes, tops....
When I checkmark "White" & "Red" & "Tops", then I click "Populate Comments",
it will show the comments seperated by commas like this: "White, Red, Tops".

Need to copy to the clipboard automatically and ready to be copied
elsewhere. The popup comments dialog needs a cancel button also.

Any simple ideas?
 
Any simple ideas?

Nothing simple about this at all. You'd have to create a userform and a
fair amount of VB code as there is nothing built into Excel that will do
this. So your options are to pick up a book on VB or hire someone to do it.
Of course someone may also volunteer to donate several hours to you. If so,
send me his name as I'm in need of some free window washing at my place.<g>
 
Back
Top