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...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    • Replies: 31
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    • Replies: 26
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    • Replies: 24
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    • Replies: 23
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    • Replies: 23
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    • Replies: 23
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top