| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Retain values of combo box
This is the code I have:
Private Sub CommandButton1_Click() Dim code_series As Range Range("code_series") = CodeBox1 UserForm1.CodeBox1.Value = Sheets("Input Sheet").Range("z2").Value UserForm1.Hide End Sub The funny thing is, on my work computer, the last value entered was retained in the codebox, but on my home computer, it is not. Anyone see anything wrong with this code? Thanks, Greg |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy and replace xlsm files, but retain the values in selected cells... | Excel Discussion (Misc queries) | |||
| Values to Combo Box | Excel Discussion (Misc queries) | |||
| Add two cell values, retain it, and add another value | Excel Worksheet Functions | |||
| registering the cell values of excel combo box associated values | Excel Programming | |||
| After Workbook closes all my combo boxes do not retain dropdown list. | Excel Programming | |||
Threaded Mode
