Yes.  I was a bit nervous about the lead up to it, but on the day I was told exactly what would be happening and the surgeon had a monitor screen which showed me what was actually happening inside of me during the op (this is for more his benefit than mine).  I must say I was fascinated by the whole op going on on the monitor screen that I almost forgot that there was someone inbetween my legs.
The operation itself doesn't really hurt.  I'm sure your dr has already explained to you what will be happening and the surgeon will explain again on the day.  You will be injected with a local, which is pretty painless.  Once it's kicked in the surgeon uses what lookes like a small chicken wishbone with a copper wire attached at the widest part which is very hot (it's the only way I can think best to describe the instrument, however I had mine done several years back so things may have changed). This is inserted and the copper wire then cuts through the piece of flesh that has the abnormal cells and cauterizes as it cuts, to minimise bleeding. 
It's a very small and simple procedure and it can be a bit nerving, but in my experience as I said before I was more fascinated on the day.  It's just fear of the unknown and the lead up to it I found more nerving.  Also the surgeon will tell you to avoid putting anything up there and sex for about a week to 10 days.  I'm a slow healer and waited 10 days and sex was still quite painful, but if you heal quite fast you should be fine.
I really hope it all goes well for you.

Hugs for the day
Dexi
xxx

This government sucks with all these NHS cutbacks.  I usually go for a smear every year now rather than the usual 3 just to be on the safe side. But the last time I went for one, back in Nov it had only been 11 months and the nurse told me that the lab will just throw it out as it's not been 12 months due to back logs and cut backs.  I was amazed. I had to make an other appt for Dec.

A colposcopy is really just a smear but a little more done ie the spray you have that the Dr uses to see any chance in cells.
After my first when I was 24 and laser treatment for abnormal cells I had to have colposcopys for a further 3 years 6 monthly twice then every year for 2 years to check everything was ok, it was and now I am due my first 3 yearly smear this August.

Don't worry hun apart from the spray thing which just tingles a little bit its not that scary although I know the not knowing what its like is terrifying