Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
double click option in listbox outputs to cell in excel 97 !
Hello, First off... The solution has to work in excel 97 ! I am having a little trouble trying to figure this out. I have been able to get a simple listbox, to get a range of data from another worksheet in the same workbook, and it works just fine. However, my issue where I'm stumped, is if I could double click on a single option and it would output that same option to a specific cell in the same worksheet as the listbox ? Thank you VERY much in advance, spyrule. -- spyrule ------------------------------------------------------------------------ spyrule's Profile: http://www.excelforum.com/member.php...o&userid=25489 View this thread: http://www.excelforum.com/showthread...hreadid=560541 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
double click option in listbox outputs to cell in excel 97 !
Hi SpyRule,
Try: '============= Private Sub ListBox1_DblClick(ByVal _ Cancel As MSForms.ReturnBoolean) Me.Range("A1").Value = Me.ListBox1.Value End Sub '<<============ Or, using the simple change event: '============= Private Sub ListBox1_Change() Me.Range("A1").Value = Me.ListBox1.Value End Sub '<<============= --- Regards, Norman "spyrule" wrote in message ... Hello, First off... The solution has to work in excel 97 ! I am having a little trouble trying to figure this out. I have been able to get a simple listbox, to get a range of data from another worksheet in the same workbook, and it works just fine. However, my issue where I'm stumped, is if I could double click on a single option and it would output that same option to a specific cell in the same worksheet as the listbox ? Thank you VERY much in advance, spyrule. -- spyrule ------------------------------------------------------------------------ spyrule's Profile: http://www.excelforum.com/member.php...o&userid=25489 View this thread: http://www.excelforum.com/showthread...hreadid=560541 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Double Click within Cell | Excel Discussion (Misc queries) | |||
double click on cell that have link, Excel will jump to the refere | Excel Worksheet Functions | |||
In the Project window where will be the double click option | Excel Worksheet Functions | |||
Need selected item from listbox after double click | Excel Programming | |||
Click on graph bar to execute a double-click in a pivot table cell | Charts and Charting in Excel |