VB Write User Form Data to Excel

[Shazz]

Hi All,

I have a code below to write the data completed in a user form to excel but it is not working, can anyone see what the problem is with it at all. Also doe anyone know how I can link to a PDF document through the userform?

Please Login or Register  to view this content.

I would apprcaite anyones help.

Shazz

[Kyle123]

IN this line, .Parent is unqualified, you haven't set the range

Please Login or Register  to view this content.

[Shazz]

Sorry I may sound a bit thick, but not sure what I need to do, I am using this code in another sheet and it works fine??

[OnErrorGoto0]

In the other sheet you must have a With range(...) type statement which is not present here as Kyle said. Change this

Please Login or Register  to view this content.

to this

Please Login or Register  to view this content.

[Shazz]

It is still not working unfortunately, I am still getting an error, I have attached my workbook, could you have a look for me and see where I am going wrong.

Thanks

[OnErrorGoto0]

You don't have a sheet called Sheet1!

[Shazz]

Ops, sorry your right, how did I miss that lol.

A couple of questions for you, can you use links within a User Form, i want to be able to click on a link in the userform that will go direct to a PDF Form outside of excel, also is there a way of viewing the data within the userform as well as on the Excel Sheet, and have Find record, First, Last, Next Record like in Access??

Thanks for your help.

Shazz

[Shazz]

When I add data to the form it keeps overiding the same row all the time, do i need to add to the code so that each new data go into the next row?

Shazz

[OnErrorGoto0]

Try

Please Login or Register  to view this content.

[Shazz]

No this now flags up an error on the "RowCount = .Cells(.Rows.Count, 1).End(xlUp).Row - .Row + 1"

Please Login or Register  to view this content.

[OnErrorGoto0]

My mistake - remove the

Please Login or Register  to view this content.

part.

[Shazz]

Ok done that, now the error comes up at .Offset(RowCount, 0).Value = Me.TextBox1.Value

Shazz

[OnErrorGoto0]

That is not in the code I posted?

[Shazz]

It is still showing an error

Please Login or Register  to view this content.

[OnErrorGoto0]

What error?

[Shazz]

I have now managed to sort it out, sorry for all the bother.

Could you advise if I am able to use the user form like excel and view the records from the userform and not the spreadsheet, with buttons like next Record, first, search fro Record etc.

Thanks you in advance xx

Shazz

[OnErrorGoto0]

Yes but only if you add those buttons and the appropriate code. You may want to look at the built-in data form (if you have not already) or John Walkenbach's Data Form add-in.

[Kyle123]

Do you have a "Textbox1" looks like it should be:

Please Login or Register  to view this content.

[Shazz]

Sorry Kyle not sure what you mean by this?

Do you have a "Textbox1" looks like it should be:
Code:
Me.TxtLocation.value

I am very new to User Forms, does anyone have any examples that can show how to go about using it for view Data as well as entering data, I also need to know how I can enter a hyperlink in a user form too.

Thanks
Shazz

[Shazz]

Sorry Kyle not sure what you mean by this?

Do you have a "Textbox1" looks like it should be:
Code:
Me.TxtLocation.value

I am very new to User Forms, does anyone have any examples that can show how to go about using it for view Data as well as entering data, I also need to know how I can enter a hyperlink in a user form too.

How do you look at the Built in Data Form

Thanks
Shazz