userform help

  1. X

    UserForm make option button and textboxes mandatory

    Okay. So i have created a userform with several textboxes and optionbuttons. What i have achieved until now is that ceartain textboxes are mandatory and have to be filled. But i dont seem to get it with the optionbuttons and i dont know why. the if statement is as follows: If Me.ADA.Value...
  2. X

    Several VBA Userforms Questions including formulas in the Userform and uneditable textboxes.

    Ok. I am fairly new to the whole userform thing, but i find it really useful for what i want to do with it. But i still got several questions about it. 1. I have managed toget a fairly big userform to work and enter all those values in a table. But i figured out that when i use the userform to...
  3. G

    A comparison of a set range of columns in to another on the same sheet to highlight rows with differences...

    **I do not have rights to attach my workbook. :confused::confused::confused::confused: I don't even know if this is possible....I have no idea how to code a comparison of a set range of columns with another range of columns and then flag the rows with differences to insert an image in a frame...
  4. A

    UserForm to send email

    Hello All: I'm hopping someone can help me with this so if you know, please do Help!!! I have office 2007 and run WinXP I created a userform with 2 text boxes, 2 Checkboxes, a send button and a cancel button. I need a code will allow the user to click send, and it will send the information on...
  5. C

    Userform & VLOOKUP to populate fields

    I am new to Userforms, but have successfully created one where all entries work - except one. I am creating a Userform for a student directory. If I create a user as NEW, it works fine. However, I have information from previous years that just needs to be updated, not NEW. This information...
  6. K

    User Form, Combo Box, Moving Entries to spreadsheet

    G'day, Could someone please assist an amateur in the transfer of data entered on a user form so that it appears on a spreadsheet. I have created a user form with 4 text boxes labelled as: "Job Number"; "Customer Name"; "Suburb" and "State/Country. The next two entries are combo boxes labelled...
  7. R

    Need to view sheet3 data in sheet1....help

    Hello all excel experts. I have a fairly simple problem that my inexperience is making difficult.I have a column A and column G list generated in Sheet3. I have build a simple droplist interface in sheet1 to fill in the additional data for Sheet3 columns B,C,D,E & F. Here is my problem. I need...
  8. J

    Userform Help Please

    Hi All, I am new to this forum so apologies. I was wondering if anyone could offer me some assistance / point me in the right direction. Basically I would like display certain data from a given row in a spreadsheet via a userform which can be opened via a command button and take the...

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top