Ok, I have a listbox that sources a list of peoples names from a spreadsheet. When the user enters the listbox and clicks on one of these names I want a seperate independant textbox to update with the selected persons name.
I could do this by adding a button and assigning the code to that but I would prefer it to do it automatically every time the selection in the listbox changes
woolls01
Last Activity: Jan 29 '08, 04:33 PM
Joined: Jan 17 '08
Location:
-
I just want a textbox to update with the information in the field, just a small piece of basic code that I want to auto update when the listbox selection changesLeave a comment:
-
Listbox items
I want a macro to run every time an item in my listbox is selected, rather than add a button to do this I d like to know how I can do this?
I am using VB in word -
Yes but what code do i need to select the nth file?Leave a comment:
-
There are about 8 files in the subfolder and there 'll always be the same number of options in the listboxLeave a comment:
-
Selecting a file by its location rather than its name
I have a listbox and would like to use it to select a file from a known location, but I want to select by position as its name may change (example: if someone selects the first option in listbox then the first file within the folder d:\workpack is selected).
Thanks -
I have no idea what that means but it did the trick so thanksLeave a comment:
-
Returning subfolder name with path name
I am using the following code
Sub Ck()
Dim strStartPath As String
strStartPath = "d:\workpack\rr a"
ListFolder strStartPath
End Sub
Sub ListFolder(sFol derPath As String)
Dim FS As New FileSystemObjec t
Dim FSfolder As Folder
Dim subfolder As Folder
Dim i As Integer
... -
Tabbed Userform
I have a userform with several tabbed sheets within it, what code do I need to use to select different tabs automatically in VB?
I want to be able to tell the macro to run page 1 on startup and a "next" function on each sheet to select the next tabbed sheet
No activity results to display
Leave a comment: