cbotemp

I have the below VBA coding on 3 of my sheets in an excel workbook. My excel crases after few minutes, can someone suggest if there is anything wrong with the coding Private Sub Worksheet_SelectionChange(ByVal Target As Range) With Sheet1.DTPicker1 DTPicker1.Value =...

I have the following code that reveals a ComboBox when a target cell is double clicked Private Sub Worksheet_BeforeDoubleClick(<wbr style="font-family: Arial, Helvetica, sans-serif;">ByVal Target As Range, _ Cancel As Boolean) Dim str As String Dim cboTemp As OLEObject Dim ws As...

I'm using what is similar VBA I see in examples on the web of a ComboBox which looks at the validation in the cell and retrieves the list for the ComboBox. However, the code is designed for all the lists on the same worksheet. I have the lists on a different sheet. If I explicitly fill the...

Hi, I am still try to figuring out about this On Error Statement. I have a case in Debra Dalgleish post (http://www.contextures.com/xlDataVal10.html) about "Excel Data Validation Combo Box". Here the code: Option Explicit ' Developed by Contextures Inc. ' www.contextures.com Private Sub...