prompt

  1. H

    Forms - Prompts for a List using Data Validation

    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...
  2. B

    Restricting use of one cell based on another

    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...
  3. S

    Event still triggers after setting EnableEvents to False

    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...
  4. T

    Application.GetSaveAsFilename Prompting on Read Only Files

    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...
  5. G

    Need help with macros for excel worksheets...

    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...
  6. E

    Checkboxes based on range

    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...
  7. P

    Warning Messages Conditional on Cell Values

    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...
  8. P

    Loop Macro. Prompt input.

    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...
  9. B

    Workbook Protection Password Prompt Macro

    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...
  10. J

    Need Excel 2k to auto-number using a prefix of my choosing

    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...
  11. E

    VBA and password prompts

    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...
  12. L

    Question to input a value into a pop up box

    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...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top