default values

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

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

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

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