Hi folks, just a few quick Excel VBA questions relating to a multiline textbox. Apologies if these have been covered previously.
TextBox = TextBox & A & vbtab & B & vbTab & C & vbTab & D & vbTab & E & vbTab & F & vbNewLine
Can vbTab or any alternative be made to function similar to the tab key in Word (irrespective of fixed/non-fixed font size)…is there any textbox-solution to guarantee column line-up?
Thanks, Jim.
- I’m trying to send 6 visually separated columns of data to a textbox. Each of the 6 columns will be 1-8 characters in length and the data will extend downwards from 1-2000 lines.
TextBox = TextBox & A & vbtab & B & vbTab & C & vbTab & D & vbTab & E & vbTab & F & vbNewLine
Can vbTab or any alternative be made to function similar to the tab key in Word (irrespective of fixed/non-fixed font size)…is there any textbox-solution to guarantee column line-up?
- I could use 6 listboxes (or 6 textboxes?) – would it be feasible to suppress a vertical scrollbar to all but the right-most list/textbox and then allow the user to scroll down, while at the same time, linking the current scroll position with the remaining 5 boxes? (each box will have identical Listcounts).
- If there is a data limit on the maximum size of each textbox or listbox (we may extend to around 5000 lines in the future), apart from using Access, is there any other way we can display this data to the user. VBA will be used to search and filter this data so a significantly less amount would be displayed to the user.
- Are there any issues using VBA from a business perspective, in the context of standalone (VB6) support being withdrawn by Microsoft….I take it MS will support VBA?
Thanks, Jim.