Problem with the user form

[Eric Tsang]

Dear Guru

I have made a form and want to add the new record to the bottom of the list

Currently, it overwrites the record from the 1st row

How can i do it .

Please find attached

Eric

[davesexcel]

You are counting the rows for column A, maybe count the rows for column C instead.

Please Login or Register  to view this content.

[dotchiejack]

Hi,
This works

Please Login or Register  to view this content.

And to add the date of today in your textbox.

Please Login or Register  to view this content.

[Eric Tsang]

Dear Sir

I have not idea how to remove the hyperlink of .Cells(NextRow, 8) = txt_tel

as when we input the no. it underlined with hyperlink .See attached

Please Login or Register  to view this content.

[Eric Tsang]

Dear Sir

I have no idea how to remove the hyper link on the
.Cells(NextRow, 8) = txt_tel

Please Login or Register  to view this content.

[davesexcel]

Please Login or Register  to view this content.

You may have to reformat the cell, it could look like there is still a hyperlink.

[dotchiejack]

On the start tab (Home?)-> Styles -> choose Standard

[davesexcel]

Just format the the cell the way you want it to look.
You can also click a cell with the correct format, click the format painter(paint brush), then click the cell you want to format.