Name not getting captured in 2 input userform

[dimitrz]

Hi Guys

I recently added one more input sheet " Helpdesk" in a workbook already having a input sheet " MEVOS"

The module 2 has codes for the original input sheet "MEVOS" whereas module 4 has the code for input sheet "Helpdesk"

Problem faced by me is though everything thing else works fine - the Helpdesk input sheet is not capturing the user name " Jane Evans" like the " MEVOS" input sheet

Input sheet Helpdesk captures data in London/LA/Liverpool Trackers / sheets

Input sheet MEVOS captures data in L1 & L2 tracker/sheet

Thanks in advance for assitance

Sample enclosed in XLM and 2003 XLS format - I am using excel 2007

I think Module 1 can be ignored - It was the first module created and I believe the original created forgot to delete it off

Ps:Having trouble uploading the sample - i'll try to upload its soon

[Bob Phillips]

Without seeing the workbook, I canot even begin to understand what you are saying. Get it up quickly

[dimitrz]

Sample excel 2007 version

[dimitrz]

Excel 2003 version

[dimitrz]

Any tips

[austenr]

Tips? I can't even understand the problem. Looks like Jane Evans is on the helpdesk sheet.

[mdmackillop]

Unless you specify otherwise, arrays start at 0. By starting your loop at 1, you miss the first value.

 
For i = 0 To UBound(SourceCells)

[dimitrz]

Tips? I can't even understand the problem. Looks like Jane Evans is on the helpdesk sheet.

sorry I couldn't respond in time to your query since I was on sick leave

[dimitrz]

Unless you specify otherwise, arrays start at 0. By starting your loop at 1, you miss the first value.

[Code]
For i = 0 To UBound(SourceCells)
[/Code

Thanks a bunch Malcolm - it works

You are a champ

If you are ever in India give me a buzz - Dinners on me and maybe a couple of drinks after that

[dimitrz]

Mods request you to place " Solved " in the subject

[dimitrz]

Mods request you to place " Solved " in the subject line

Issue resolved

[Bob Phillips]

You can do that, from the Thread Tools dropdown at the top of the thread.

[dimitrz]

You can do that, from the Thread Tools dropdown at the top of the thread.

Thanks - I was hunting for the option in edit tab