PDA

View Full Version : Drag & Drop?



doctortt
04-25-2011, 12:15 PM
Hi, I need to build a VBA progam where the user needs to select certain values.

Instead of creating option buttons, is it possible to create something in which the user can drag the selection and drop it into somewhere in the program?

Kenneth Hobs
04-25-2011, 01:04 PM
I am not sure what you mean. They can already drag and drop if the worksheet is not protected and cells are unlocked.

You can use Application.Input with the type as 8 to let them pick a range.

If you are in a userform, you can set the ShowModal property to False or set it when you Show it.

doctortt
04-25-2011, 01:09 PM
thanks. do you happen to know where I can find an VBA sample program with drag & drop? I searched the Internet, but all I could find was the codes..

Bob Phillips
04-25-2011, 01:57 PM
Note Kenneth's suggestion of ... Application.Input with the type as 8 ...