Using vb to control access to Excel the cell data source drop-down box-CodePudding

Home > Software engineering > Using vb to control access to Excel the cell data source drop-down box

Using vb to control access to Excel the cell data source drop-down box

Time：09-28

VB code:
. RowSource="Sheet2! A1: A49 said "//" set the source data area, data source of drop-down list box
If use VB code how to obtain the Excel table drop-down box of the currently selected cell sources? How to write
. RowSource=Application. ActiveCell. The Columns? So to

CodePudding user response:

Application. ActiveCell. The Columns are selected to the current column

Page link：https//www.codepudding.com/Softwareengineering/38443.html

Prev:How to VBA to realize the screening for help

Next:Control flow endofstream windowsmediaplayer came to an end at the end of the video won't trigge

Tags：

VBA

Links：
CodePudding