No, no, no! Don't freak out and start reinstalling everything because of a simple error! It just means that what you are asking for is not available. Chances are that you have more than one workbook open and the one with focus is not the one with the info you need. Or you have the wrong sheet in focus??? Granted, you activate the sheet in the code, but did you rename it? Any typos? Unfortunately, although I know VBA...I'm lousy with the Excel objModel. If you don't get a code fix here, try posting to my Excel VBA group here: http://groups.yahoo.com/group/ExcelVBA Dian D. Chapman Technical Consultant, Microsoft MVP MOS Certified, Editor/TechTrax Free MS Tutorials: http://www.mousetrax.com/techtrax Free Word eBook: http://www.mousetrax.com/books.html Optimize your business docs: http://www.mousetrax.com/consulting Learn VBA the easy way: http://www.mousetrax.com/techcourses.html -----Original Message----- From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf Of robert.allen-turl@xxxxxxxxxxxx Sent: Tuesday, August 29, 2006 5:22 PM To: mso@xxxxxxxxxxxxx Subject: [mso] Run Time Error 9 - Subscript out of range. Need help on the following: Visual Basic was working perfectly over the weekend but it now falls over at stage 1.. This morning I started to build a form to record names (checkbox) and addresses (text box). I wrote the following opening code: Private Sub UserForm_Initialize() ActiveWorkbook.Sheets("Input Sheet").Activate Range("A3").Select With cboxClient .AddItem "Edwards" .AddItem "Johnson" End With End Sub Tried to Run Sub/User Form to check the names appeared in the Checkbox. 'Pop-up' appeared saying: Run Time Error 9 - Subscript out of range. Don't understand what this means. Will I have to reinstall Windows and Office? Appreciate any feedback Robert Allen-Turl 79 Calver Crescent Sapcote Leics LE9 4JD Tel: +44 1455 272762 Fax: +44 1455 271478 Mobile: 07818 272762 ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, visit the group's homepage and use the dropdown menu at the top. This will allow you to unsubscribe your email address or change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso To be able to use the files section for sharing files with the group, send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with instructions. Once you are a member of the files group, you can go here to upload/download files: http://www.smartgroups.com/vault/msofiles If you are using Outlook and you see a lot of unnecessary code in your email messages, read these instructions that explain why and how to fix it: http://personal-computer-tutor.com/abc3/v28/greg28.htm ************************************************************* ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, visit the group's homepage and use the dropdown menu at the top. This will allow you to unsubscribe your email address or change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso To be able to use the files section for sharing files with the group, send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with instructions. Once you are a member of the files group, you can go here to upload/download files: http://www.smartgroups.com/vault/msofiles If you are using Outlook and you see a lot of unnecessary code in your email messages, read these instructions that explain why and how to fix it: http://personal-computer-tutor.com/abc3/v28/greg28.htm *************************************************************