cellserow

  1. I

    Userform copy rows of data into worksheet but ignore blank rows

    Hi there I have created a user form with rows of data for the purposes of using as an order form. At present there are only 3 rows but I eventually want to add further items. I am trying to apply coding that will review each line of data on the userform to see if it contains values and if it...
  2. A

    Autofill Formula in next line

    Hi ive been working on a VBA project (Note: im still a novice and google everything I need to know) Ive developed a userform to capture some employee details and in the process to calculate the days to expiration of set dates against every new employee... The sting that I use are as follow...
  3. ExcelNooberino

    Change Interior.Color VBA

    Hello to you all! So, I'm working on this new UserForm to add some new entrys of info I need to keep track of the data. Basically it has some textboxes and a couple of comboboxes and I'm struggling to change the cell color of the last field (combobox) in the database. It only has two variables...
  4. A

    Merging worksheets into a master sheet (with formulas and formats intact)

    Hi all I'm really hoping somebody maybe able to advise as I've been racking my brains out on this. I'm working on a project where I need to merge multiple excel worksheets (to be supplied by different owners- but in a consistent format) into a single worksheet. I've made a fair amount of...
  5. R

    user form with check boxes

    i have a user form with three frames in it "full day", "first half", "second half". in each frame there are 7 check boxes, each check boxs represents a day. a user should be able to come in and check of which days they want and depending on which frame they choose it represent a full or first...
  6. R

    Issue specifying worksheet

    i have a user form that gathers some data. The following code continues to dumb the info onto the active sheet rather then sheet 13 (request log). i need it to populate the data on that sheet every time rather then on the active worksheet. Dim erow As Long erow =...
  7. M

    Runtime error '424' issue

    I am running into the runtime error '424' Object required issue. I am using the variable eRow in order to enter data from a userform into the next available row in a excel sheet. I can't find any issues with the code, it was working a couple weeks ago. Here is a shortened version of what I am...

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