userfrom vba

  1. C

    Userform: Find date in worksheet and put data collected from Userform list box in the next empty rows

    I have a Worksheet named ANAESData "ANAES Data Entry" and a userform named: ufANData that has three list box lbxDate (single option select) data from a named range rngDate which has 2 columns lbxName (single option select) rngANAESNames lbxShifts (Multi option select) rngShifts which has 2...
  2. J

    Userform DTPicker won't show correct date when feed to cell

    I have a Userform with a Date Picker field called "DTPickerLaunch" When the form is initialized code reads as below so it defaults to today + 30 days (this works fine). The issue is when I transfer the field value to my sheet. On one Userform (UserformScopeLodging) the date is transfer/display...
  3. F

    copy data from one workbook to another

    HI, i have been using excel to create invoices. unfortunately i had to change the format of the invoice and add some more details to it. the problem i am facing now is i have to change all the old invoices as well (around 150+). i am looking to create a user form to do this. old workbook cell...
  4. M

    Setting path to folder as varible and using it.

    Good afternoon. I've hit a dead end. After looking for quite a while and tested a few things I've given up. Probably a no-brainer to some but I cannot get my head around it. Is there somehow I can save a specific path to a folder " C:\user\folder1\Subfolder1" and then call upon a variable to...

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