cut and copy from comboboxes

tallpaul321 · Mar 8th, 2002, 02:17 AM

How can i cut and paste data from a combobox in visual basics into and cell in excel?

Ivan F Moala · Mar 8th, 2002, 02:47 AM

Quote:

On 2002-03-08 01:17, tallpaul321 wrote:
How can i cut and paste data from a combobox in visual basics into and cell in excel?

Excel2000

Userform Modal set to False
Userform dragbehaviour = 1 frmdragbehaviourenabled

Now just select the data and Drag and drop
into cell.

To do a cut & paste I beleive you will
need a textbox and some API calls

Ivan

Dave Hawley · Mar 8th, 2002, 04:08 AM

If you don't have Excel 2000 or even if you do, how about:

Private Sub ComboBox1_DblClick(ByVal Cancel As MSForms.ReturnBoolean)
Cancel = True
Sheet1.Range("A1") = ComboBox1.Value
ComboBox1.Value = vbNullString
End Sub

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 8th, 2002, 02:17 AM	#1
tallpaul321 New Member Join Date: Mar 2002 Posts: 5	How can i cut and paste data from a combobox in visual basics into and cell in excel?

Mar 8th, 2002, 04:08 AM	#3
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	If you don't have Excel 2000 or even if you do, how about: Private Sub ComboBox1_DblClick(ByVal Cancel As MSForms.ReturnBoolean) Cancel = True Sheet1.Range("A1") = ComboBox1.Value ComboBox1.Value = vbNullString End Sub