prompt

Hi, I want to write a macro in Access (not VBA) and run various queries with the same criteria. This criteria is however not fixed and requires the user to enter the value. Can anyone suggest me the best way to do this? If I use VBA macro to prompt the user to enter the value once, how can...

Is there a way for VBA to prompt the user for a new selection?. For exmaple, Sub BlankRow() The reason I need this is because I am already in a macro and can not change selection on screen and I don't want to exit routine to make new selection (last line of code). 'I need to be able to...

I am creating a business form using excel 2007. I have fields that I would like to have a drop down list in. I would like for that field to have a prompt message that appears without having to click on the cell first. So that if you opened the sheet say cell B2 would say "Yes or No" and then...

If a user fills out one cell, I want to restrict them from filling out another cell within a certain range. And if they try to do so, I want them to be prompted with a message box explaining the restriction. eg. <TABLE style="WIDTH: 155pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0...

Hi all, i have a procedure which unloads a userform. When this userform is loaded, one of the textboxes are setfocused on (textbox1.setfocus). This textbox has validation codes in its BeforeUpdate event. If wrong text is entered, there will be a prompt. In the procedure i have the...

I've just upgraded to Excel 2010 from 2003. An internal add-in that is heavily used uses the Application.GetSaveAsFilename method to prompt for file names to be used for an export process (exporting information from the current Excel file into an xml configuration file). In 2003, even if they...

I need to write macros to do two things... 1) I need to delete all records in a worksheet for which column F contains a comma OR a specific substring, "Dwl:" (which is part of a longer string..."Dwl:Hse,Tlr,Apt, Dup"). 2) I have worksheets in which column A contains house address numbers. I...

Hi, I am using Excel 2007 and I need to provide a set of checkboxes for use in creating a chart. These will be checkboxes on a worksheet rather than a userform, so I will be using "Developer, Insert, Form Controls" to put the checkboxes on the worksheet. Rather than fixed text against each...

Hi everybody. I have a spreadsheet where people add information, and other spreadsheets that do calculations to check that the information entered makes sense (for instance, that the quotient between two values is less than X). I would like to refine the process, so that automatically prompts a...

Hi, I have several hundred workbooks with multiple worksheets(15-35) that I am trying to tidy up, so the data can be entered into a database. Its my first attempt at VBA and between the forum and macro recorder I made an attempt which is below. I just can't seem to get over the last part. I have...

Hi, I have a tab that I want to remain hidden to all who do not know the password. I want the tab to become visible via clicking a button which runs the following code Sheets("Project Deletion Form").Visible = True However the workbook is password protected and I would like the user...

Hi Mr. Excel Community, I am working on a spreadsheet to track the results of manual software testing. Each spreadsheet contains many test cases, and each test case has a unique ID. The test case ID is used by formulas in the spreadsheet to generate statistical information. I would like to...

I have a read only workbook that multiple users use to send data via code to a master database. The master is password protected and the code enters the password upon opening. Each time the master is open for a split second, but very occasionally, two users may try and access it at the same...

I have two values that I want to paste into a template after I've pasted the template into a new worksheet. Let me try and explain clearly... In the macro I have now it opens a specific workbook and copies a template, then pastes it into the new workbook that I am working on. I would like...