message

hello i have data in sheet1 begins range from a2:c10 and userform contains 3 textbox the column c contain values when i fill data in textbox3 and press enter i would show the message " avalible is 200 or 300 or500.etc if the entered number in textbo3 more than what in column c my...

Hi When I run the code below, I get this message But that defeat the purpose. I mean, if I entered file name as Hello.xlsm, sill I get that message. How can I improve that code? By the way, if I save the file as "*.xlsm" before running that code and then when I run the code below, I wont...

Hi Not sure why My1 is not accepted as macro name. I opened a new excel file then went to developer--> record macro--> then typed my1 as a name for the macro but got error message. Thank you very much.

Hi, For the life of me this doesnt work, any ideas? Many thanks Sub Clear_Estimated_Hours() Dim Msg, Style, Title, Help, Ctxt, Response, MyString Msg = "Do you want to continue ?" ' Define message. Style = vbYesNo + vbCritical + vbDefaultButton2 ' Define buttons. Title = "Delete...

I have a people list for my company that I work for. We want to keep track of training for each individual associate. We have columns AI through AV starting on row 3 set up with our different lines. We rate their level of training 1-4. So we want a brief message to pop up when one of the cells...

Hi everyone, I use a macro to update certain worksheets in a workbook across 2 computers.. The problem is that i have 4 different macros for each sheet, I know i can put them all into 1 Macro to achieve this, except upon update because both workbooks are not always containing the same data it...

Anyone know how to clear this issue. I get this message with any query I run associated with this table and can't find this table anywhere now. I no longer see tt in my relationship either. I tried deleting my import table and rebuild it but, I can't do that either. RAW_NJUNS is the name of my...

Hello I need vba code to check a range of cells for value greater than zero. Ive set the range = colval If there is no value in the range greater than zero I want a message box "No Value > 0" Thanks for any help

Hey everyone, I am having some issues with a message box popping up 3 times for each scenario in the code below. I tried using Boolean values as explained in similar posts, but that just made the problem worse. Basically, there are two cells in question. I'd like for one message ("A") to pop up...

In column CB I have list of items then CE has their respective values. Now the items in CB are grouped into four - meaning each group has same value. So I need a way to display with a message box - VBA: Group 1 = Value 1 Group 2 = Value 2 Group 3 = Value 3 Group 4 = Value 4 I have been...

Hi, I have got here a very simple macro that copies three values to a worksheet from a userform and then it opens a new email message and it pastes these values into the email message. The userform has 3 text boxes and 1 command button: TextBox1 TextBox2 TextBox3...

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 believe the code supplied below is what you require. I have a worksheet database where i send out parcels to customers & once parcel is received i like to make a note of the date on my database. I have a drop down list on my userform which looks at the worksheet & loads any customers name...

Hello does any one know if it possible to have text flash for say 15 seconds to tell the user of an error. I have an if statement in cell c2 with an error message and if the error messages appears I would like the message to flash for say 15 seconds. Thank you if any one can help

I am using Excel 2019 which I just download from Microsoft. I deleted the old Microsoft office which had word and excel because I was getting an error message. I am trying to enter stock symbols in column A and in column B I have the following =xlqprice(A3, "yahoo"). I have used this formula...

I have a table and the first column for a row is the date. If a date is entered that is earlier then today's date, a message box should appear and ask you if that is what you want. It is just to add an extra layer of protection against typos. If a new row is added then a date entered that is...

Hi, Not sure how to do this but I want to have a cell display various message text depending the value input into another cell e.g. if value in cell D10 = 1 then in cell D8 I want to see the message Change if value in cell D10 = 2 then in cell D8 I want to see the message Pump Out I...

Hello, I am getting an error message which states "Sorry, we could not find C:\Users\Simon\Downloads\QuotesAddIn64.xll. Is it possible that it was moved, renamed or deleted"? This file was for an add in that I unsuccessfully tried to install. I have searched my PC for the file without...

Hi all. I want to validate a textbox to confirm email has been entered correctly. I remember this being an issue in the past and it seems it still is. I have been using the code bellow and was feeling that, I don't want the OK message if the email is okay but rather want a user message asking...

I have been creating a 24 page workbook for simple accounting for a non profit group. I've updated the pages and used the "Save As" option from books volume 1 (initial) to volume 5. Now when I try and open my volume 5 I get a long list of error and it asked me if I want to correct them yes or...