A customizable GUI that interfaces easily with VBA when working with Microsoft Office products.
0
votes
0answers
21 views
Excel User Form Value Find
I currently have a spreadsheet which as 6 columns these are -
In this spreadsheet, i have created a button that the user press's which then brings up a userform i have created, the userform looks ...
1
vote
2answers
23 views
VBA: Userform initialize method not being hit when userform initializes
My module code calling the userform:
PreInfo.Show
My userform code:
Public Sub PreInfo_Initialize()
Dim Invoice, Name, Model, Crank, MyValue1, StrokeL As Variant
'Dim ListBox1 As ListBox
Dim c As ...
1
vote
1answer
26 views
Excel Userform - get HTML from clipboard
Excel 2010, 2013
I have some HTML on the clipboard and I want to parse it via an Excel UserForm.
I can retrieve the formats on the clipboard using VB.Net and "HTML Format" is listed in the returned ...
0
votes
1answer
33 views
Modeless form that still pauses code execution
Is there anyway to have a userform that acts modeless, while still pausing code execution like a modal form?
I'd like the userform to show, but still allow interaction with the parent program. Modal ...
-6
votes
1answer
64 views
How to create an User Interface (UserForm) in Excel/VBA
I have written VBA code for excel and it is working fine (MACRO). Now I want to create UI file for excel .
Can anyone tell me how to create UI file?
Thanks in Advance.
-4
votes
1answer
53 views
Catch activated user control c#
I am working with C#. I was wondering how to catch an event when a user control is activated?
I have created a document manager with DevExpress using windowUIview.
On the start page, I have tiles.
...
0
votes
1answer
45 views
Draw border around controls on VBA Userform without using a Frame?
I am designing a VBA UserForm (in Excel, if it is relevant) and I would like some controls to be visually grouped together.. but when I put them in a frame, I am getting some undesired results (part ...
0
votes
1answer
216 views
Userform listbox filled with pivot table values - excel
I am trying to load a listbox with the rows from a pivot table field. I have found the following code that works for a ActiveX Control Listbox, but not for a UserForm Listbox. The UserForm control ...
0
votes
1answer
62 views
Copy data from one part of a userform to another automatically
I am trying to work with an Excel form using VBA that I have customized (I found the original on the web).
I have two tabs: one is called Planning-Deleted, the other is called Planning-Deleted Data. ...
0
votes
1answer
52 views
How do I create a user form that can set the variables in an SQL query before executing it?
I have data that is entered on an ongoing basis in SharePoint; this table is linked in MS Access and, once a month, I freeze the data by copying it from the live SharePoint database into a static ...
0
votes
1answer
4k views
Excel VBA - Assign value from UserForm ComboBox to Global Variable
I have a userform with a basic combobox and command button. When the user hits the command button, I want the UserForm to close, and the value of the combobox to be saved in a variable that can be ...
0
votes
1answer
371 views
What VBA coding in a Userform can I use to find a cell based upon row & column content, and then update that cell?
I am a complete beginner to VBA, truely.
I am trying to create a user form that will update the number of tasks a person completes on a given date as listed on a spreadsheet. I envision the Userform ...
0
votes
1answer
2k views
Align Userform to cells in Excel
I'm attempting to position a userform (named UserForm1) in Excel to align with cell references in Excel. If I initialize the form using the first code below, the userform is correct size positioned in ...
1
vote
0answers
102 views
Combobox_Change function for combobox's created with .Controls.add function*
Let me start by saying that I have searched far and wide for hours before answering this question.
Situation (all working) -
User is to specify the number of apples in a basket
Example - user ...
1
vote
2answers
260 views
VBA - copy text from Combobox in User from and paste in loop onto excel worksheet
I am new to excel VBA and I have tried to adapt some of the solutions found on Stack Overflow, but I'm still stuck!
I am trying to use the text of a selected option in a combobox in a userform to ...
