-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
scrollbars
-
VBA MsgBox customized to display data in tabular format _ (Data arranged in straight rows and columns)
Hi all, As you probably know, displaying text data arranged/aligned in straight columns inside the standard vba MsgBox is extremely difficult. I personally have never seen this done before... Calculating the msgbox font size is a nightmare. Here, I am using a few api-based workarounds to...- Jaafar Tribak
- Thread
- beginpaint createwindowex fillrect gettextmetrics hcbt_activate hiword icc_listview_classes initcommoncontrolsex listview lvm_approximateviewrect lvm_first lvm_getitemcount lvm_getitemrect lvm_settextbkcolor lvs_nocolumnheader msgbox paintstruct removewindowsubclass setwindowsubclass syslistview32 tabular msgbox textmetric wm_paint
- Replies: 5
- Forum: General Discussion & Other Applications
-
J
Dynamic Maximum Value for Scrollbar (Form)
Hi team, I'm trying to set a max limit on my Form Scrollbars (I have 4 unique named scrollbars on sheet "dash_v2"). I have COUNTIFS formulas (in cells) on sheet "dash_v1" calculating total references, i.e. 2 of this, 31 of that etc... Those references are the numbers I'd like to use as a...- joetogo
- Thread
- dash_v1 forms sheet vba & excel
- Replies: 0
- Forum: Excel Questions
-
C
Adding Vertical and Horizontal Scrollbars in a userform using Userform_Activate method
Folks, I have to add both vertical and horizontal scrollbars in a userform, so far I have this code below for horizontal scrollbars only. Private Sub UserForm_Activate() With Me .ScrollBars = fmScrollBarsHorizontal .ScrollWidth = .InsideWidth * 1.5 End With End Sub The...- CakzPrimz
- Thread
- end horizontal vertical
- Replies: 2
- Forum: Excel Questions
-
B
VBA Code to generate controls on a userform
Dear Mr. Excel, I've searched quite a bit but can't find the appropriate search term to zero in on the answer, or it just can't be done. (Never!) I am designing a form that needs a variable number of ScrollBars. I need to generate scrollbars from within a loop, so that there is 1 scrollbar...- bbrother
- Thread
- userforms
- Replies: 3
- Forum: Excel Questions
-
F
Scrollbar changing userform textbox and cell in a sheet. (number only increases)
Hello, I am creating a userform to manipulate a sheet and expose only some information of the sheet to the user. Basically I have a cell, on this example A1, where it is supposed to be a temperature and that temperature will affect many other calculations on the sheet (for simplification the...- finaljustice
- Thread
- change cells manipulate sheets textbox
- Replies: 6
- Forum: Excel Questions
-
W
Positioning scrollbars in Excel 2010 VBA
Hi, I need to switch User Forms programmatically from Left-To-Right to Right-To-Left. It is simple to change texts, lists, etc. But scrollbars in Combo Boxes remain on the same side, obstructing start of the listed items. In older versions of Excel, Combo (List) boxes had a "Scrollbar"...- Wanderer7
- Thread
- api calls vba
- Replies: 0
- Forum: Excel Questions
-
R
Scrolling in a UserForm Frame by a Code
Is it possible to scroll down in a UserForm Frame with a VBA Code in excel. My frame in the userform has a scrollheight of 600 and a lot of option buttons. Based on a selection in a ComboBox(using If statement), I'd like to scroll down to a certain amount in the Frame. Does anybody have any idea...- rajsingh0621
- Thread
- code excel vba
- Replies: 7
- Forum: Excel Questions
