Hi

I have a problem with a VBA form I've created in Excel. I have set u
an OK button which, when clicked, takes the information that has bee
inputted on the form and puts it on to a worksheet.

Here is a sample of the code:

Range("c1").select
ActiveCell.Offset(0, 1) = txtCountry.Value
ActiveCell.Offset(0, 2) = txtRegion.Value
ActiveCell.Offset(0, 3) = txtStreet.Value
ActiveCell.Offset(0, 4) = txtName.Value

where txtCountry etc are the fields on the form.

When I run this macro, it goes incredibly slowly, although correctly
Although it is a reasonably large spreadsheet, I do have a fas
computer and I would not expect this. It is taking about half a secon
to add each item.

Any ideas as to why this is happening would be greatly appreciated.

Thanks
Jame

--
Message posted from http://www.ExcelForum.com