ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Objects in cells (https://www.excelbanter.com/excel-programming/325758-objects-cells.html)

copyco

Objects in cells
 
Is it possible to put objects into the cells on a worksheet (combobox,
textbox, etc.) intead of them floating on top of the sheet? Like when
you have autofilter on, it makes the top cells into comboboxes that are
resizable with the cell. Can this be done in VBA?


Dick Kusleika[_4_]

Objects in cells
 
You can put a combobox in a cell by using Data-Validation. It doesn't have
all the features of the ActiveX combobox and there's no substitute for any
of the other ActiveX controls.

--
Dick Kusleika
Excel MVP
Daily Dose of Excel
www.dicks-blog.com

copyco wrote:
Is it possible to put objects into the cells on a worksheet (combobox,
textbox, etc.) intead of them floating on top of the sheet? Like when
you have autofilter on, it makes the top cells into comboboxes that
are resizable with the cell. Can this be done in VBA?





All times are GMT +1. The time now is 11:18 AM.

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