PDA

View Full Version : [SOLVED:] Name not getting captured in 2 input userform


dimitrz
03-05-2010, 01:56 AM
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
03-05-2010, 02:19 AM
Without seeing the workbook, I canot even begin to understand what you are saying. Get it up quickly :)
dimitrz
03-05-2010, 02:25 AM
Sample excel 2007 version
dimitrz
03-05-2010, 02:26 AM
Excel 2003 version
dimitrz
03-07-2010, 08:08 AM
Any tips :(
austenr
03-07-2010, 07:25 PM
Tips? I can't even understand the problem. Looks like Jane Evans is on the helpdesk sheet.
mdmackillop
03-08-2010, 03:18 PM
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
03-16-2010, 12:52 AM
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
03-16-2010, 12:53 AM
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 :bow:

If you are ever in India give me a buzz - Dinners on me and maybe a couple of drinks after that
dimitrz
03-16-2010, 12:54 AM
Mods request you to place " Solved " in the subject
dimitrz
03-16-2010, 12:56 AM
Mods request you to place " Solved " in the subject line

Issue resolved :)
Bob Phillips
03-16-2010, 01:39 AM
You can do that, from the Thread Tools dropdown at the top of the thread.
dimitrz
03-17-2010, 09:13 AM
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 :)