I have created several workbooks all practically with the same code
they were created with excel xp i have now loaded them on to my work
network which use excel 97 everything seems to work fine except th
userform......on the whole the user form works, it pops up on deman
when a cell is selected in the range and it also has a populate
dropdown list but when i select some text from the list the box jus
closes without putting the selected text in the active cell.

Any Ideas?

I have tried to upload workbook on here but it says the file size i
too large even though its only 300kb, so i can mail it to anyone wh
can help!

Simo

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

I have looked at the code i have on each sheet, if i comment out th
code that selects all sheets it will allow the userform to functio
correctly, but i need that functionality....can anyone help???????

Simo

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

You can send it to me



but I won't have access to Excel 97 until much later today.

--
Regards,
Tom Ogilvy

"Simon Lloyd " wrote in message
...
I have looked at the code i have on each sheet, if i comment out the
code that selects all sheets it will allow the userform to function
correctly, but i need that functionality....can anyone help???????

Simon


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

Thanks Tom!,

Workbook has been mailed

Simo

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