valid

Sub getCountryFile() Dim filePath As String filePath = "z:\allUK\EVR" If Len(Dir(filePath)) > 0 Then Workbooks.Open (filePath) Else Debug.Print "doesn't exist" End If End Sub Where filePath is valid, and the Workbooks.Open works fine if tried outside the...

Hi Team, i need to validation the zip code, locality name and state. currently i am keying the data and validating manually with address data base available in excel while validating i am following bellow procedure... 1st Priority is ZIP if zip code found then search for locality name and...

<tbody> Check Status ID Valid 123 Valid 234 Invalid 345 Valid 345 </tbody> I am looking for a formula (or possibly a macro) to place in the first column where it checks the ID column. If there is more than one row for the same ID, it looks at the status for all of them, and if just...

Hyperlink Problem says [The address of this site is not valid. Check the address and try again] Please help. Some are ok while few did not work at all. I got pop message says "The address of this site is not valid. Check the address and try again"

Does anybody know a way of programmatically detecting the antivirus status in Outlook? The equivalent of manually, in Outlook, navigating to File > Options > Trust Center > Trust Center Settings > Programmatic Access and checking the Antivirus Status at the bottom (It should read "Valid" but...

Is it possible to show a tick mark on a user form? I want to show the user then the entry made is either valid or invalid with either a tick or a cross. TIA

I saved a chart as a template in Excel 2010, however when I try to utilize it I receive the error message: "therm.crtx:file format is not valid". Can you explain to me why that might be? Thanks!

Hi, new here. I am currently working on a excel project. I have a list of valid values for each column in Style 1, 2 3 4. For example Style 1: Red Green Yellow Style 2: High Low Up Down Style 3: Dog Mouse For Instance, I have a few columns: Description, Description_2 ... that contains many...

Hi! I wonder if anyone can help me understand this in my opinion very strange VBA behavior (or if I miss something obvious). I have a Macro where I check if the content in an Excel cell can be interpreted as a cell reference. If so I do something if not I do something Else. A simple test...

I need help with my for-each loop VBA logic. I have been tasked with modifying my VBA code to find files with specific date stamps. Until I get access to the MonthView control, I have added msgboxes to prompt for a start date and end date. For each file in my collection, I plan to test the...

Dear all, could you please help me return different notes for old and new entries considering the date (column A)? I would need for newest row insert note ''valid'' in column C. And for rest - older rows, I would need note ''old'' in column C. <colgroup><col><col><col></colgroup><tbody>...

I am trying to secure a worksheet using data validation. I want to prevent users from pasting over data validation fields, however I want to allow users to be able to still use the paste feature as long as the data is valid for the data validation. How can I do this VBA code? I am using data...

I need to check a string for unwanted characters (only valid HEX characters allowed, 0-9, a-f, A-f) sub unwantedCHAR() Dim IPv6_Address As String IPv6_Address = ThisWorkbook.Names("IPv6_Address").RefersToRange.Value Dim ipv6_segments() As String ipv6_segments = Split(IPv6_Address...

Hi, I have 3 sheets in a Workbook named in the brackets. 1. The main LOGIN sheet(Login) 2. Second sheet containing list of 101 usernames and passwords in column A and Column B respectively (Admin) 3. The sheet which you navigate to after logging in successfully. (Metric) I need a VBA code to...

Hi all. I want to ensure users are putting valid dates into a column, say A2:A100. I would like a default text entry of 'Not Known' to be valid as well in A2:A100. Date and text validation is not that straightforward, can anyone help? Thanks.

Hi Forum Hope you can help I have an issue with Pivot tables in Excel. Issue: I down load a workbook from another application. When I create a pivot table it counts inconsistently as follows: Column A = 56 Col B = 32 Valid Fields 24 Blanks Col C = 37 Valid Fields 19 Blanks Col D = 15...

I've made a spreadsheet using drop down validation lists. It works for all users except for one person. They are using Excel 2007 on a Windows 7 computer. They cannot see the arrow to show the list of options. The cell is not locked. If the user types in a valid entry, it works. I've tried...

I am having a problem with dependent validated options using INDIRECT. Please see illustration. https://www.dropbox.com/s/fnlyewqsux7rh0k/Indirect_validation.xlsm.png The goal is to make the valid options offered in column I dependent on the selection made in column H, using =INDIRECT(A2) to...

Good afternoon, I looked through multiple posts on the forum boards, but something is not working properly with my code. I was hoping some of you VB experts can help me. What I wish for it to do = look up errors in a column, highlight the erroneous cells red, and popup a msgbox once saying...

My conditional formatting code is not seeming to be working. I have two columns - one of which has a vlookup. What I wish to do is do conditional formatting on the column without the vlookup. So if the vlookup returns an #N/A, the conditional formatting should highlight the cell Red, and put...