Search results for query: *

I have just networked my old Win95 pc and now it insists on asking me for a network password on startup. Is it possible to stop it from doing this? Many thanks to anyone who can sort this out :-)

I dont want people to access the VB Editor in Excel from within a userform. Is it possible to disable the 'Ctrl + Break' key combination in a userfrom or multiple userforms? -- Henry

The '.ClearContents' method seems to work ok. Thanks guys.

Im trying to clear all the data from an excel sheet. Im probably being stupid but i cant seem to get it right. It works if there is data, but somethimes if the sheet has no data it gives me an error. Is this the right code? Worksheets("Sheet1").Range("A1:D100").Clear Im not...

Im trying to copy cells from one sheet to another. This is the current code im using: For x = 0 To 10 Worksheets("sheet1").Range("A2").Offset(x, 0).Value = Worksheets("sheet2").Range(currentcell.Offset(x, 0)).Value Next x Although every time I run it doesnt...

Would it possible to copy the contents of a listbox into the column of a spread sheet? When i try it only copies the selected item not all the values. Im new to VBA and this is for a school project. If you can help me then thanks.

MANY Thanks thats sorted it all out!

I have a listbox with three columns, i can add items to the first column but not to the second or third. Ive tried using Additem but it only adds the items to seperate rows and not to the same row in the first and second column. Ive tried using this: ListBox1.AddItem TextBox1.Text...