| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
select listbox item automatically
I hv 2 listboxes on userform.. If user is selecting the text of listbox1 then get its index and select the text of listbox2(index of listbox1) next also remove the selected item from both listboxes on clicking remove btn. -- ilyaskazi ------------------------------------------------------------------------ ilyaskazi's Profile: http://www.excelforum.com/member.php...o&userid=23969 View this thread: http://www.excelforum.com/showthread...hreadid=467414 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
select listbox item automatically
Private Sub cmdRemove_Click()
Range("A1").Offset(ListBox1.ListIndex).Delete Range("B1").Offset(ListBox1.ListIndex).Delete End Sub Private Sub ListBox1_Click() ListBox2.ListIndex = ListBox1.ListIndex End Sub This assumes that the source of the listboxes is A1:A10, B1:B10 -- HTH Bob Phillips "ilyaskazi" wrote in message ... I hv 2 listboxes on userform.. If user is selecting the text of listbox1 then get its index and select the text of listbox2(index of listbox1) next also remove the selected item from both listboxes on clicking remove btn. -- ilyaskazi ------------------------------------------------------------------------ ilyaskazi's Profile: http://www.excelforum.com/member.php...o&userid=23969 View this thread: http://www.excelforum.com/showthread...hreadid=467414 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
select listbox item automatically
Although i wanted the help for userform's listbox, it is solved takin some similar codes It is perfect as always, Mr Bob.. Thankyou -- ilyaskaz ----------------------------------------------------------------------- ilyaskazi's Profile: http://www.excelforum.com/member.php...fo&userid=2396 View this thread: http://www.excelforum.com/showthread.php?threadid=46741 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
select listbox item automatically
i do not want to accept any item in listbox if it is already existing show msgbox of already exis -- ilyaskaz ----------------------------------------------------------------------- ilyaskazi's Profile: http://www.excelforum.com/member.php...fo&userid=2396 View this thread: http://www.excelforum.com/showthread.php?threadid=46741 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding item in listbox | Excel Worksheet Functions | |||
| Item order in ListBox | Excel Discussion (Misc queries) | |||
| Add item to listbox, but only if it is not already there. | Excel Programming | |||
| Select an item in a listbox using code | Excel Programming | |||
| The value of a ListBox Item | Excel Programming | |||
![ilyaskazi[_71_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
