Posts by ski1382

Thanks for your very quick reply!

So I have to refer to them by number and not name? That I was certainly doing wrong.

Is the first page "1" or "0"?

J

This is going to be an easy win for one of you guys but its got my head aching as it is not as straight forward as I thought it would be!

I have a multipage userform, the first page is working just the way I want, the ability to search, edit and add new staff. Now I need to start working on the second page which will essentially be allocation of work etc. Most of the time this will all be done from page two but I would like the option to be able to click a different command button on page 1 which will then jump to page 2.

Any thoughts?

J

Thanks both for your assistance! Working nicely now

Thanks all for your replies, sadly nowhere near a computer right now!

I hadn't gotten round to putting in a button to bring up the form yet, wanted it working correctly first

Will get into looking at them shortly, thanks very much

Thanks for your reply...

Not sure how to attach a file so here is a link to the file in OneDrive (fake data only)

https://1drv.ms/x/s!AnGA9LzbQiBKvD_BuZpFTT3aSKcD

I'm fairly new to VBA but have been having some degree of success, but this has got me well and truly stumped. I have a form with a list box, several text boxes and two combo boxes. When the form loads, the list box is populated with staff names and when a staff member is selected all the information relating to them populates the text boxes and comboboxes - all good so far.

The issue arises when I want to edit the data in the boxes, I am using the code below to send the data to the worksheet...

Private Sub cmdSave_Click()
CurrentRow = txtRow.Value


Dim WS As Worksheet
Set WS = Worksheets(1)


With WS
    .Cells(CurrentRow, 2).Value = txtSurname.Value
    .Cells(CurrentRow, 3).Value = txtFirstName.Value
    .Cells(CurrentRow, 4).Value = txtEmployeeID.Value


End With
End Sub

This succesfully sends only the first change, the other two remain exactly the same regardless of what changes have been entered. Interestingly though, if I deactivate the first row with an ' (apostrophe) then the second line is the only one which changes. It feels like I am missing something really obvious but I cannot figure it out.

Any help gratefully appreciated!