I work on an Excel application in where I retrieve data from an sql-server.
I want to use the excel sheet to edit the data.
Sometimes this data is a date and I want to use the datepicker
As all workbooks and sheets are generated with VBA, I need the correct sysntax to add the datepicker. (I don't want to use a form)
To add a activeX button I use this code to create a button:
Set objBUT = ActiveSheet.OLEObjects.Add(ClassType:="Forms.CommandButton.1", Link:=False, DisplayAsIcon:=False, Left:=r_Button.Left, Top:=r_Button.Top, Width:=r_Button.Width, Height:=r_Button.Height)
I was looking for the correct class description but haven't found it so far.
Maybe someone can give me a hint.
Mike