资讯

TechRepublic16 年

10 ways to reference Excel workbooks and sheets using VBA

Excel offers myriad options for referring to workbooks and sheets in your VBA code. See which methods make sense in which situations.
TechRepublic10 年

Pro tip: Populate an Excel UserForm combo box without VBA

Susan Harkins shows you two easy ways to populate an Excel UserForm, and neither requires a single bit of VBA code.