form design

  1. R

    Generating auto year in VB

    Hi I am creating a VB form, which updates a spreadsheet, and as part of this creates a unique reference number. I want the Ref number to be CUST/YY/unique number I am struggling to get the year automatically, I have tried a couple of ways but it didnt work. Currently I am using the below...
  2. G

    Default to Current Date in Excel Form Textbox

    Hi All, I have a worksheet with a command button that opens an Excel form named frmMain. On that form I have a frame named fraMain that has a textbox named txtDate. (The first field on the form) I'm trying to get the current Date to populate the textbox automatically while also allowing the...
  3. J

    Copy & Edit Excels default Data Entry Form

    Hi all, I have a spreadsheet that has 36 fields, some of which are for data entry and others that have formulas within which calculate and display output based on the data input in the previous fields. Due to the number of fields required for each record, the spreadsheet looks quite...
  4. 9tanstaafl9

    Brain fart. Can't find button properties to change button name.

    Sorry for the idiotic question but I've searched for an hour now and can't find it. I have an old excel worksheet with a button on it that needs to be renamed. Last time I renamed a button I thought I had just right clicked on it and properties was an option and I could type over the button...

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