Back to the brick wall!!

[Robert Couchman]

Hello all,

remeber a while ago i had a problem with a time table...

well.. i need it for definate now!!

i wish to create a listbox that will hold a list of all
the people who have not arranged a time (list needs to
contain ref, name, lastname) (but only shows name lastname)

i then need the update command to realise that if i select
a blank or a different name off the list, the old names
details will be updated (puts a blank in the appointment
time for record) and thus, will update the new selected
records details with the new time

any sugestions to help me come up with a final working
model will be very welcome, if you would like to view the
spreadsheet or current working files, please e-mail me on
(e-mail address removed)

Thank you,

Robert Couchman
([email protected])

 

[BrianB]

The first step, before trying to write any code, is to organise th
procedure into the various tasks, and decide which order they are to b
carried out.

It is then a good idea to list them in a macro sheet with an apostroph
in front so VBA knows they are comments and not code. You can the
write the code underneath each heading. Test each set of code befor
going to the next.

Here is some code I use to put paths/filenames into a 2 column list bo
from a worksheet. (Listboxes count from zero up)

'-------------------------------------------
'- initialise form with file names from worksheet
Private Sub UserForm_Initialize()
Set DataSheet = ThisWorkbook.Worksheets("data")
Set MyList = DataSheet.Range("FileList")
Rw = 1
FileListBox.Clear
While MyList.Cells(Rw, 1).Value <> ""
FileListBox.AddItem
FileListBox.List(Rw - 1, 0) = MyList.Cells(Rw, 1).Value
FileListBox.List(Rw - 1, 1) = MyList.Cells(Rw, 2).Value
Rw = Rw + 1
Wend
End Sub
'---------------------------------