Excel can perform custom data verification, so this operation can be achieved entirely within Excel, taking the upper and lower values and giving a popup if anything outside those parameters is entered anywhere within a given range. It's in >Data >Data Verification >Data Tools I think then it's >Se...

Here is my latest code and it works fine at the first value and not works at the second value. I just adjusted some time delay and changed the location of the time delay in the program. Still not getting it works. XLOpen>C:\Users\...\149405.xlsx,1,xl Wait>3 SetFocus>149405 - Excel Let>row=15 Let>col...

Hello All, Trying OnEvent today on my spreadsheet to capture the out of spec value when operator keys in. The scripts work fine in debug mode but in run mode nothing shows up when the wrong value is typed in. Any thoughts will be appreciated. Here is my code: XLOpen>C:\Users\...\149405.xlsx,1,xl Wai...

Hello All,
I am getting a problem of closing a dialog.
Run on scripts then the dialog is closed perfectly. But it is not closed when run on executable file.
And the scripts run differently than the exe file. ???
Any ideas will be appreciated.

Thanks

Thanks a lot for your response. I have some questions. Why do you use the double quotes for subroutine? And codes don't work. I added some delay time and it worked but sometime it did not work I don't know. Below is my revised code: XLOpen>C:\Users\Documents\149405.xlsx,1,xl Wait>3 Let>row=15 Let>co...

Hello ALl, I am try to create a script that monitor a cell in the spreadsheet. When the operator enter a bad value then a warning popup window will occur. When excel is opened and I enter the value into that cell, nothing happen if the value is out of Specification. But the code does not work. I app...

Thanks. It worked now.

And I am not able to set the dialog3 position to the second screen.
I am using these:

Thanks a lot Dorian.

Hello All,
How to create 2 or three dialogs and show them all on screen?
I would like to create two of them and show each of them on my two screens. (one screen one dialog)

Thanks

Hello All,
I am not able to open excel file by using xlopen command on Windows 10 pro.
Any advices?
XLOpen>C:\Users\mabdulah\Documents\QSF-Template\QSF.xlsx,1,xl
Thanks

Can you please share your spreadsheet with us , so that we can help with almost accuracy? I am also curious about this, I am new to learning VBA. Insert Column: VBStart Dim i, start_col, end_col, y Dim link Sub Insert_col(link, j, save_link, x) y = x - 6 Const xlToRight = -4161 Set objExcel = Creat...

Hello all, I am trying to use VBA to add and delete columns in my spreadsheet. The VBA just works for adding. Deleting not working at all. The spreadsheet template is designed with 8 samples and sample number one starts at column 6. The goal is: If job has more than 8 samples then macro will add mor...

Thanks Dorian.
Copy and paste. Easy

Thanks Dorian but it is not single or double quote on the keyboard.
I tried it but did not work. That text is extracted from my pdf files and I think it is different formatted.