user

I've been fighting with application.quit for a while now because it wouldn't close excel. I had this in the open even and first check to see if the user had read write privileges to a folder they will need for everything to work. I got that squared away by putting and Exit Sub after the...

Hi community, I want to know how can i calculate numbers between specific rows? if user selects January from data validation list i want excel to calculate numbers from January to august, if May than from May to August. btw user can select start and end date. so it can be from january to may...

Hi Excel gurus, Could someone please help me. I have a report with users group assignment in the system. Users are assigned to read-only and full access groups. Email address is the unique field in the report. I wanted to apply a formula under User ID's so we we can identify and filter if...

Good afternoon all, Is it possible to display a chart/pie chart in a User form?

Hi everyone, I have a textbox on my userform called "SerialTxt" what i am wanting to do is when a user enters an alphanumeric number with special characters "-" i want that textbox to check cell "P1" on a worksheet called "Data". If the value is the same then allow the user to continue, if the...

I am constructing a macro to perform sorting on different selected named ranges provided by a user form which has a combo box and I do not know what best practice is: Call the user form from within the macro or call the macro from the user form. I would appreciate any advice and...

Hi With a help from Fluff, I created the code below. It is asking user to enter 3 numbers then the code will msg out these 3 numbers. I want to improve this code. I do not want to limit user to enter only 3 numbers. I want a user to enter any number and I will create a loop depend on how many...

Hi, I'm usually an Excel person and not so much an Access person so please forgive my stupid question: I plan to build a database which in various forms rolling up into various tables I want to control selection choices a user can make. Some of these list might be 3 options long, some might be...

Hi friends. How to do: the user start capture in cell A1="APPLE" go to A2 and capture "ORANGE" and then the user capture in A3="APPLE" here how to check every capture if exist say a message: "Error, captured on A1" or only can do the task, with a button and with vba code? thanks

Hi I want to write a code (for learning purpose) asking user to enter 10 numbers or whatever user going to enter then the code will find the max number from these number and print a message saying "number ?? is the max you entered". Can that be done in VBA? Thank you very much.

Hi The code below takes several sheets in a Workbook and saves each sheets as its own Workbook. It saves the workbooks in the same directory that the source wookbook is saved. But Id like to prompt the user once to select a folder where all the workbooks will be saved. How do I do this ...

Hello I am working on an excel file with 7 sheets. The main interaction that a user will have with the worksheet is through a user form. The user form as multiple pages and one page is already completely functional. The next page, however, is giving me a lot of problems. The first problem I am...

Is there a way to freeze a shape so that it behaves like freezing cells? I want to freeze a shape so that it always stays on the screen even when a user scrolls.

Hi - I have an excel sheet that has 3 fields:- C2 - Trip Limit C3 - Trip Start Date - dd/mm/yyyy C4 - Trip End Date - dd/mm/yyyy If a user enters a Trip Limit of 20 in C2 and if the End Date in C3 minus the Start Date in C4 is more than 20, I would like an error message to either warn the...

Hi. I have a source worksheet with 8 separate datasets. I want the user to be able to indicate which of the 8 datasets they want to copy/paste from this source worksheet into the destination worksheet. I can write a macro that will allow the user to indicate one, several or all eight of the...

I built a macro in Excel 2010 that does a Vlookup from one spreadsheet to another, and when the macro is run, a popup box appears and lets the user click which tab they want the macro to perform the Vlookup on. I used the following code and it was simple and very effective. Dim cbTool as...

I have a user form with several option buttons After selecting an option button and clicking on Ok, I would like the button to show the last option button selected it would be appreciated if someone could advise me how to do this

I have a user form that provides the end user with a simplified display of information, I need to populate a text box with the word 'Blocked' if the value in the workbook = 0

Hi there, I am making a userform. I have to checkboxes, checkbox1 and checkbox2. I want to make it such that user can only check one of them at tiime. And I also want to make it as mandatory question for the user such that he or she needs to tick one of the checkboxes! thanks for your help

Afternoon All This question is in reference to a calendar that keeps track of the 7 employees attendance. In my sheet, Cell AI20 is user entry of the first date. Cell AI21 is the user entry of the second date. Once the user enters the second date, the selected (dates) cells are highlighted...