ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Select from List Box (https://www.excelbanter.com/excel-worksheet-functions/119815-select-list-box.html)

Franko

Select from List Box
 
Have a list of names & Phone# in list box on Form1, want a macro to copy
selected names and paste to a table. Table is a subform in Form1(no
relationship). All field names and format are similar)

I have
the form is 'Form1'
the list box is SelectNames
the table is ListOfNames(subform name is fsubListOfNames)

Macro -- (On Dbl Click)

GoToControl -- fsubListOfNames
GoToRecord -- New

SetValue -- Item -- [Forms]![Form1]![fsubListOfNames]
Expression -- [Forms]![Form1]![SelectNames]

I step through the macro, and ok until SetValue, then error message. Please
help.



All times are GMT +1. The time now is 06:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com