-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
strwsname
-
A
userform listbox add items but not if they are marked cancelled
When adding items to a listbox, how do i avoid ones marked "Do Not Use" (DNU). This is where I am picking up my listbox contents: Private Sub FillResults() Dim ws As Worksheet Dim rngFound As Range Dim strFirst As String Dim strSearch As String Dim strWSname As String Dim...- ajm
- Thread
- dim end marked rngfound strwsname
- Replies: 8
- Forum: Excel Questions
-
A
userform listbox - using find to populate
hi all, i'm using the following code to find a particular name in my workbook, and then return particular cell value from the sheets on which it is found. Public Sub search() Dim ws As Worksheet Dim rngFound As Range Dim strFirst As String Dim strSearch As String Dim...- ajm
- Thread
- dim getsearcharray listbox rngfound strwsname
- Replies: 7
- Forum: Excel Questions
-
G
Find Sheet
Hi Guys, Could you please check what's missing? I want to find sheet even though part of its name only is being searched. Sub FindWS() Dim strWSName As String strWSName = InputBox("Enter the sheet name to serach for") If strWSName = vbNullString Then Exit Sub End...- gerald24
- Thread
- dim end find sheet strwsname
- Replies: 19
- Forum: Excel Questions
