default values

  1. P

    How to set default Values for a Userfrom and call the Userform

    When I click the button that calls up the userform, the userform comes up, but none of the default values I have picked show. I am using Excel 2010. How do I fix my code? Sub NewTranslationRequest()'Fill Default Data OptionButton1 = True OptionButton2 = False OptionButton3 = False...
  2. ClimoC

    Which is quicker/more efficient? Lots of 'If Not IsNull()'s or setting Default Values = ""?

    In my access, I've had to set a lot of fields to have default properties to avoid runtime errors (and since it's Excel based ADO objects, I have no Nz() function) But I also have a bunch of text and memo fields, which when I just wrote a 'duplicate record' function, was returning the 'Invalid...
  3. S

    Date Picker changing cell format

    Hi there, Here's the issue I'm hoping someone can help with (I've pieced the solution together from some code I found here: http://www.contextures.com/xlDataVal14.html That link explains how to insert a combo box in fields that are using data validation from a list (to take advantage of...
  4. W

    Adding default values to cells

    Hi All, I am having some difficulty adding a default value to a cell. What I want to do is have a cell that will read "Enter value here" if nothing has been added, but display the users text when changed. I've been playing with the IF statement feature for a while, but am getting...

Watch MrExcel Video

This Week's Hot Topics

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
Top