Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I receive a error message code 9 "Subscript Out of Range"
when the VBA code for retreiving information from an editbox in a dialog box. All editboxes in my dialog box have a name. For example: My dialog box is in a dialog sheet named "BoMSetUp", Editbox is named "RONum", Worksheet is named "BoMform". I want to take the entered text of the "RONum" editbox and insert that text into cell "C4" in my worksheet "BoM form". The code reads "Sheets("BoM form").Range("C4").Value = DialogSheets ("BoMSetUp").EditBoxes("RONum").text. When running the macro i receive the error message code 9. Can anyone help me? Thanks, Gary |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Dialog Pop Up Box | Excel Discussion (Misc queries) | |||
How to delete the "Insert Function Dialog Box" (dialog box only)? | Excel Worksheet Functions | |||
Use of Dialog | New Users to Excel | |||
Go To Dialog box | Excel Discussion (Misc queries) | |||
dialog box | Excel Discussion (Misc queries) |