default value

Hello, I have been trying to find a solution to creating a Data Validation List that shows a default value (the top item in the list). I found a solution on this board that sort of works. Is it Possible for a Drop Down Menu to have Default Selections? Post #3 seems to work....but only to a...

Hi, I've been struggling with this problem for awhile. I've made a form out of ActiveX controls, vba codes etc. I am almost zero knowledge about vba. I've made a combo box, named cmbDate. ListFillRange of the combo box is Q11:Q13, where there are formulas in this cells: Q11...

I know we can make a criteria by getting a parameter but I need to give a default value on user's prefrence. Possible in a parameter query?

I have a user table that I use in a Login Form. Once the user has logged in they have access to various forms. I have a query that returns the current user logged in. I would like to populate the default value in the combo box. I have been able to populate the default value with the form value...

Hi I have posted something similar to this before. I have a spreadsheet whereby I want a formula or <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help; color: rgb(51, 51, 51)...

Hi I have a spreadsheet whereby I want a formula ir VBA code to apply depending upon if another cell contains anything. For example A1 contain text. In B1 the user can add text, but if it is left blank then I want a dash ("-") as the default value. If A2 doesn't contain anything then I want...

I'm trying to set up a default value for a text box. It will be a file path that contains an ampersand. Everytime the form is loaded the text box evaluates the ampersand and so it disappears. C:\J&B changes to C:\JB and so the subsequent code doesn't run. Is there a way to escape the...

Hello all. I need to force the entry in a cell to be within a certain range of values depending on the input in another cell NOTE: I cannot use validation since I have already used validation to restrict the cell in a different way already. Hence my thought that a macro is the way to go...

Hi I would like to be able to define a default value for a field in an excel table that carrys forward to new rows in the same way formulas do. Any help appreciated! Regards, Si

Hi, I've read that the default valuie of a Boolean variable is set to "False". However, i have the following piece if code where the default value seems to be "True". Function checkForFree(longTr As Boolean, opType As Integer, goingS As Boolean, curZone As Zone) As Facility ' rest of code...