Please Login or Register to view this content.
Please Login or Register to view this content.
What is lbl2? A label? Are you trying to get the contents in? It will be me.lbl2.caption if so.
Hope this helps
Sometimes its best to start at the beginning and learn VBA & Excel.
Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
Available for remote consultancy work PM me
i am still getting the same error
its label
i am trying to get data
see i have attached my sheet
Last edited by baig123; 09-03-2014 at 06:02 AM. Reason: paragraph
Do you definitely have a control named 'lbl2'?
Can you upload an example workbook?
Click on GO ADVANCED and use the paperclip icon to open the upload window.
If posting code please use code tags, see here.
What data from a label? It only has caption
i have uploaded the user login details file
in that userforms
Last edited by baig123; 09-03-2014 at 06:17 AM. Reason: paragraph
The VBA project is locked.
sorry for that see this file
You haven't set ws to refer to any worksheet.
i am trying submiit data to my excelsheet called(workstation.xlsx)
You have this in the code but obviously it's commented out.
Try uncommenting, and if needed change 'Login Time' to the required sheet.Please Login or Register to view this content.
now i am getting
subscript out of range
'Set ws = Worksheets("Login Time")
Last edited by baig123; 09-03-2014 at 07:08 AM. Reason: paragraph
That's because there is no worksheet 'Login Time' in the workbook.
You need to use a worksheet that is actually in the workbook.
you dont seem to have a sheet of that name!!!!
that sheet name it is in workstation.xlsx
That's the workbook name.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks