vbauser-interfacegridcontrolcatia
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.
- How do i count items in a multi item drop down cell
- Send mail based on sheet name
- VBA equivalent to Excel's mod function
- Integer Vs Long Confusion
- Export all appointments and meetings, including recurring meetings
- Word VBA macro with multiple find/replace options for single-word selection only works if the selection contains the first F/R option
- Wait until Application.Calculate has finished
- VBA Characters.Delete string over 255 characters
- Overflow when calculating a const in VBA
- problem with VBA code for vlookup from a few different workbooks
- Error when assigning a macro to a button on excel with
- Getting the actual usedrange
- Extract non-contiguous data from multiple sheets while extracting from a list with a loop
- Excel VBA - Skip renaming when cell empty
- Protected Cell warning when returning to original cell after DoubleClick
- Pass an array to a function from a multidimensional array
- Partial value font color in red using vba
- VBA to manually position an Excel pivot when AutoSort is blocked
- VBA loop through multi-d array and keep values that meet criteria in one column
- Loop inside loop. Stop second loop if condition is met
- Add attachement to email with VBA
- Search the latest saved PDF file in a various folders and copy the latest one to a specific location
- How do I get all the different unique combinations of 3 columns using VBA in Excel?
- Worksheet names in VBE
- Excel macro to identify 0 crossing of the value
- Unable to extract complete page source using selenium
- VBA collection: list of keys
- How do you copy and paste entire row of source sheet to destination when a date appears in specific column?
- Calculate average of both the columns and rows using VBA
- Automatically shows date and time in VBA on multiple columns