Search results for query: *

I'm trying to use the code below to loo thought all the combobox on a Userform and change their .text property but nothing seems to work.... <code> Private Sub CommandButton1_Click() Dim cCont As Control For Each cCont In Me.Controls If TypeName(cCont) = "ComboBox" Then...

i tought this could be done using the MID function, can't it ?

i have a cell with " Last name, First name " a comma separates the first from last name. How can I extract only the first name ? I know it's simple to do....but I only had 1 coffee today and can't figure it out :-)

can you give me some code example. I may sound smart but I"m really not !!!

ok the error problem is fixed, the code runs smoothly...but it doesn;t work...the value of cell B2 of each files is not copied into the master file....and I checked the cell are not empty.. hmmmm.....

Basically I need to acces another Excel file and get the value from cell B2 and copy if into my main Excell file into cell D1 So I'm using the following code to let the user choose the excel file where he'll extract the data from FileToOpen = Application.GetOpenFilename("Excel (*.xls)...

The code below is suppose to loop thru all the files located where the master file is and extract the value in B2 and copy it in the master file. I'm getting a file not found error at this line of code : Set wb = Workbooks.Open(strFile, ReadOnly = True) here's the code : <code> Private Sub...

I need write a macro that will check if the user is connected to the Intranet, I can't simply check if there's an internet connection. What I was thinking is to try to open an intranet page from a macro and if it returns an error then I know there's no connection...but how can I do that, ???

I need write a macro that will check if the user is connected to the Intranet, I can't simply check if there's an internet connection. What I was thinking is to try to open an intranet page from a macro and if it returns an error then I know there's no connection...but how can I do that, ???

thanks for the suggestion, tried it and it doesn't work :-(

I'm using the following loop to get the content of reg keys and then add them to a list box, the problem is that if a key is empty it gererates an error. How can I overcome this ? Also Is there another way to do this beside looping 1000 times ? There's only 5-6 keys that have content at the...

I've been trying for 2 days to find the VB code that will delete the URL history from the address bar in IE. anyone can help me ? Also can VB delete the history of the words typed in a seach engine search box...The history must be stored locally but again I can't find a way to delete it in a VB...