Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / July 2007

Tip: Looking for answers? Try searching our database.

Autopop info choices

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Sean - 28 Jul 2007 05:48 GMT
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?
Jim Rech - 29 Jul 2007 18:09 GMT
>>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>

Signature

Jim

> Newbie here.
> I would like to add an autopopulation script when activated to present
[quoted text clipped - 16 lines]
>
> Any simple ideas?

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.