userform control

Hi everybody, Briefly, What i'm trying to do is a program that creates a userform for each customer I have in a database with all the products they ordered, the details of them and a commandbutton that will work as a check. The userform helps me enlisting the orders. As every customer order...

Hi, This is my first thread post, I've looking for a solution for what I'm going to ask, for the past couple of days and can't find any so I figured I should post it hoping that I get some help.. What I'm doing: I created a userform, it's pretty complex and runs perfect on my bosses and my...

Hi there, I have userform1 with a multipage on it. I need the captions for the multipage form to be populated from specific cell values. My issue is I need the range from A7 to A15 only, but I get way more than I need with this code found earlier... Any suggestions? Private Sub...

Dear All, I have developed a user form with multiple text boxes and combo boxes. Request your assistance in writing the VBA code, which detects and pops message of DUPLICATE ENTRY, as soon as something (say ID number) is typed into the first text box or when tab is pressed to move to the next...

Hi There! I am trying to create a macro that will allow the user to select choices from combo boxes on a userform. The choice of one combo box determines what will be shown in the next combo box and so on. This will occur a set number of times (depending on what they are looking for), at which...

Hi I used to only surf over this site but now I am here with my problem in user form control I have nearly 200 toggle buttons in a user form and I want half of them "Togglebutton1" to "Togglebutton100" will toggle between "Wall" and "Slab" and half of them "Togglebutton101" to "Togglebutton200"...

Hello there, I am chancing my arm here to ask if I could possibly get some assistance with setting up a spinbutton on a userform I am building to allow me to "cycle" through a subset of rows on a worksheet that have previously been "searched" for using another command button? (I am using Excel...

Hello, Why won't "control()" work inside a moduel which is called uppon from a click action of a button?? Basically this code works fine: (inside a module and the userform button calls this macro) Sub test1() If UserForm1.CommandButton1.Caption = "Unlock" Then...

Can Anyone help? I have a userform (Data Entry Form) created but struggling to find a suitable solution to this... I would like to add a 'My Notes' box which is always display the same notes after any number of submissions of data, this is to remind the user of key information, in addition i...

Hello I'm working on a project which involves userforms and listviews. I use a hidden sheet to get a customer's data (date, shopping date etc). The data is fetched as soon as a customerID is put into cell BN41 with an advanced filter. That works OK. The problem is populating the listview with...

Hi guys I am getting the above error when executing my code, can anyone spot anything obvious? Dim conn As ADODB.Connection Dim rs As ADODB.Recordset Dim sConnString As String userid = GetName(2) sConnString = "Provider=SQLOLEDB;REMOVEDREST" Set conn = New...