Posts by mpx300

Hello,
i'm trying to navigate intranet webpage through VBA, however I'm unable to click JS button.

Sub test()
    Set IE = CreateObject("InternetExplorer.Application")
    
    WebSite = "my page"
    With IE
        .Visible = True
        .navigate WebSite
       
        Do While .Busy Or .readyState <> 4
            DoEvents
        Loop
        
    End With
    
 IE.document.getElementsByName("ClearButton")(0).Click




End Sub

the problem is that button does not have ID...

<button type="button" name="ClearButton" onclick="JavaScript:asiClearCache();return false;"><img src="/dm/jimages/eraser.png" style="height:18;width:18;border:0" alt="Clear Browser Cache" title="Clear Browser Cache">Clear Cache</button>

any idea how to clik that kind of button?

I managed to create a basic loop with comma separator only, however this solution is fine for me:

Dim x As String


  
            
 
  
        For r = 0 To ListBox1.ListCount - 1
            
        
                For i = 1 To ListBox1.ColumnCount
        
            x = x & ListBox1.List(r, i - 1) & ", "
        Next i
     Next


    
    
    
    Sheets("Sheet3").Range("a2").Value = x

do you have any idea how to reverse this action? I mean, to populate back listbox from cell. As there are comma separators only, I belive that columns number must be defined?

well, i've created code which is working with first line in listbox, however I'm struggling with proper loop through next lines. Moreover, separator between lines data should be ";".

have a look:

Dim x As String


    
    x = ListBox1.List(0)
   
        
        For i = 1 To ListBox1.ColumnCount
            x = x & ", " & ListBox1.List(0, i)
        Next i
     
    
    
    
    Sheets("Sheet3").Range("a2").Value = x

Hello Carim,
I reviwed that example before posting. It's not exactly what I want to achive...

hi,
I'm creating Useform with listbox which is feeded with data comeing from user inputs (texboxes). Listbox contains 4 columns. In short, I'm looking for some solution which may store all entries from listbox to single cell (concentration). I found some solutions which are working with one column, however there are multiple columns in my case. The idea is to use some separators like comma and semicolon. ";" would separate rows and "," would separate columns in same line entries.

On the other hand, it would be good to read this data back in listbox.