strtemp

  1. U

    Creating new sheets from every row in my database

    I had a large database in excel in which I wanted to be able to extract data from each row and create separate worksheets for each. I was able to find the following code here which has been able to do this for me perfectly: ' ' array list of fields to merge Dim strMergeFields() As String '...
  2. G

    VBA Recursive Folder search for specific Folder and File combo

    Hi I'm trying to find a set of files that contain data I want to manipulate. End goal is to collate all the data from each file matching my criteria. However, I'm struggling at the moment as the function I'm using to search is crashing out. I believe that it's failing due to either a file...
  3. M

    Multi select ListBox

    Hi, I was able to return multiple values into one cell; however, I am trying to figure out how to change my delimiter from"," to Char(10): For i = 0 To DEPListBox.ListCount - 1 If DEPListBox.Selected(i) Then 'If selected is True strTemp = strTemp &...
  4. C

    Macro to Select Multiple Items from Dropdown Checklist

    Hello, I recently found this (www.keithyap.com.au/select-multiple-items-list-excel) online and the GIF shows exactly what I'm looking for. However, the code posted there always generates an error saying invalid object. I renamed the UserForm and the invalid object error disappears and a...
    • chain55
    • Thread
    • end error invalid object private selections shows strtemp userform
    • Replies: 2
    • Forum: Excel Questions

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top