Vba activate grid control as additional control
I want to add control to user GUI that would represent excel like table but I cannot find additional control that would do that. Control like that would be used for easier data entry.
I believe that VBA has control like that and I am missing something obvious.
Does anyone know where to activate control like that?
Solution
If you have VB6 installed then, this should work:
However, if you do not have (vb6) then, another option is to create one yourself by dynamically adding controls to your UserForm (such as a textbox) and then tracking those object. It would take some work, but it would be an option.
- Easiest way to loop through a filtered list with VBA?
- VBA Hide Rows in Sheet Based on the Vlookup Value in a Named Range
- VBA run-time error '-2147221080 (800401a8)' automation error
- Excel VBA - Check if connected to internet AND if its via Wifi or Ethernet
- Remove space between an id number
- Upload file to SharePoint using REST API
- Identify Week Number, Month Number, Year from DatePicker control in VBA userform
- Enter Parameter Value Dialog Box when opening form
- Change colour of text in square brackets
- How to use Excel VBA to run WinSCP Script?
- Loop through rows in Excel to pick information to send Outlook emails runs into error on the second row
- Problem with cycling through Styles to change NextParagraphStyle - Run time error 91 - Word vba
- Excel VBA Type mismatch error with Evaluate
- Testing for NaN in VBA/VB6
- MailMergeDataSource Find Record function leads to Execute Merge Failure
- How can export all part of columns to pdf file with VBA code?
- Moving Files in MSOffice Access 2010
- How to repeat a loop until the end of my spreadsheet?
- How to get the squared symbol (²) to display in a string
- How to adjust width or position between label on y-axis?
- Filters and then sorting
- How to avoid using Select in Excel VBA?
- How do I get a range's address including the worksheet name, but not the workbook name, in Excel VBA?
- Euro symbol not showing (VBA)
- How to extract a word in a string between two similar characters" with VBA?
- Beginner is stuck with EXCEL ETL
- How do I download CSV file from investing.com
- Edit links to a new month's file
- VBA - Copy column data to new column, if data exists, use column to the right
- VBA: initializing a string array