ssheet.cellsnr

  1. R

    Userform autofill fillout ID number

    I have created a simple UserForm to enter new equipment details to the Tooling list in the spreadsheet, form works fine except for one little thing, which is New Tool ID. Basically what I need this for to do is once form is opened/called new Tool ID need to be created, which could be and...
  2. J

    Add new row data

    I am facing problem with folowing code cant add data to new row Private Sub Submit_Click() Dim ssheet As Worksheet Set ssheet = ThisWorkbook.Sheets("S") nr = ssheet.Cells(Rows.Count, 1).End(xlUp).Row + 1 ssheet.Cells(nr, 5) = Me.Tb1 ssheet.Cells(nr, 6) = Me.Tb2 ssheet.Cells(nr, 7) = Me.Tb3...
  3. RasGhul

    Userform Date entry issues

    Hi Team, I've been using the following code faithfully on many sheets, but now I'm getting a runtime error on the cdate function as I want the "me.tbdate" textbox to format as a proper date dd/mm/yyyy. for some reason without cdate a standard textbox outputs dates as mmddyy by default. How...

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