I have a userform in a Excel workbook, this userform basically has
columns, the first 2 are ComboBoxes and the 3rd is textboxes.

I have a save button where I put the value chosen (Or written in th
case of the textbox) of every control in a sheet (One cell for ever
control, cb or tb).

My problem is that quite often users will have to put the text in th
textbox between single quotes (Ex: 'Alex') but when putting the valu
in a cell, the first single quote disappears (Always the first, th
rest is OK).

What I am doing is:

Set SavQ = ActiveSheet.Range("A1")
SavQ.Offset(0, 2).Value = tbSelect1.Value

If I write ex: ''Alex' (2 single quotes in the beggining) in th
textbox then I get the desired value on the cell which would b
'Alex'.

Any ideas to why does this happen? Anyway to overcome it?

Best Regards

Noo

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