I am building a VBA code that I need to lookup multiple values into another sheet. The second part to this is I have a table which I filter programmaticall y and I only want the vlookup to match the values in that table that are filtered and return a salary value. Based on that this is what i have come up with after doing some reading but obviously not working the way it should.
What i have posted is not the complete function, just...
maxamis4
Last Activity: Jan 8 '17, 06:50 PM
Joined: Jan 2 '07
Location: Northern VA
-
Excel VBA VLookup assitance
-
I solved the problem. I had declared the array incorrectly. I only needed to declare two-dimensional array versus three. -
Excel Array issues
I keep getting a runtime error when I try to add a value to my array. The error is Run-time error '9' Subscript out of range.
I am pretty sure i have declared everything correctly but can't see to figure out whats wrong. Also the array should store string values.
...Code:Dim myarr As Variant Dim c, r As Integer Dim tbl As ListObject Dim cl As Range, Rng As Range
-
ADezil sorry for the delayed response, I solved my own issue. I have a form with 11 text controls where I need to do validation against the values entered. To do this I pass through 3 controls through a function. With in the function i delcared an array where I store the functions value and name. In the end, I used this code to change the value. dctr is the my string variable where the control name is stored.
...Code:Me.Controls(dctr).
Leave a comment:
-
Convert string to Control in VBA
Folks,
Trying to do something simple here, I want to take a value that is a string and convert it to a control. Simply put I am looping through an array and when i find a value i am looking for, i want to grab that counter and generate the control. I am using a string to put the value together and then I simply want to convert it to a control so I can assign the value. Here part of the code:
...Code:dim tmp,t, c as
-
Please ignore the question. I found the issue under a property within int he list box. Code works fine if anyone wants it.Leave a comment:
-
Excel List VBA Question
I have this sub i created for Excel. The idea is to populate multi column list box from values in an excel spreadsheet. I am stepping through the code which executes fine but no values are loaded in my list. Anyone have any ideas?
...Code:Private Sub cmdContact_Click() Dim cell As Range Dim Rng As Range 'Me.lstEmployee.Clear 'Make sure the Listbox is empt With ThisWorkbook.Sheets("Employee -
So closing the loop here on this problem. Script is perfect, (as it is in the eye of the beholder) and it seems the only issue i was having was not running the script as an administrator. Image that, i was running the script as my self (who is an admin) but not elevating it at the system. Miss the good old days of windows.
Cheers.Leave a comment:
-
Rabbit,
Sorry to wait so long to follow up. So for every record the ADSPath does have a record. oUser for only certain users does not have a value but on error function and the values that are provided do provide a date. I know this date isn't actual since i had the users reset their accounts. Also i previously had a script that worked and a certain person that should be on this list does not show up
I am attaching my...Leave a comment:
-
its with a Specific user which I know has a value.Leave a comment:
-
Rabbit,
So leveraging your code (thank you) I get the following error on record 35
Line: 35
Column: 1
Error: The directory property cannot be found in the cache.
Code: 8000500D
Source: Active DirectoryLeave a comment:
-
Rabbit,
Thanks for your response. I am trying to figure out whether its active directory or not. I am leaning to no since i actually had a piece code about 4 days ago that handled this unknown value properly.
Let me try to explain a bit more. I have this one user that keeps returning a value of 4/17/2014 5:68PM. Now for the sake of the discussion we will him John Williams. I personally worked with John and...Leave a comment:
-
Active Directory "pwdLastSet" Value issue
Hello to start off i have a VBScript not VB. I am not sure where it goes but I figured this would be a good place to start.
So I am querying AD to pull the Last Data an individual set their password. I have that working just fine but I have ran into a snag where not all individuals have a Last Password Set value. My code that I have to convert big integer into date handles the value which is null or to be more specific does not... -
I am sorry no one ever tried to answer this for you. Here is a good start for the United States:
http://www.usa.gov/visitors/work.shtml
Its not a simple process of course, your best bet is to try to get a job with a US company based out of India and then try to get a transfer back to the US. Otherwise I would start with the link i provided.
Also to get experience working with US customers I would start with...Leave a comment:
-
Rabbit,
You need the parent ID to find the primary recordset. From there loop through the multivalue list and delete the records needed.
Example:
Honda, Accord, 2011 would be the parent recordset. The multivalue list would incorporate features like leather interior, GPS, turn sensors, backup camera, etc...
Now the real way to do it is as Zmbd suggested. The problem is my client still wants to keep...Leave a comment:
-
So I found a very ugly work around and I am building the function to do it but it is killing me to think that I have to write an entire module to perform this action. Anyone have any thoughts:
Work aournd
...Code:Function Delete_Multi_value_List(AppID, SrvID) 'MULTIVALUE LISTS http://stackoverflow.com/questions/6018172/update-a-multi-valued-field-in-access 'READS ALL SHAREPOINT MULTIVALUE LISTS
Leave a comment:
-
MS Access SharePoint multi value list modification
So I am creating a UI for SharePoint via MS Access. Typically I advise my clients not to use multi value lists for junctions and it typically stays that way. However in this case the SharePoint UI will be used on some limited basis which requires the junction to be present and visible. Enter the multivalue list option.
I am have trouble with my multi-value delete query. With the multi value list I see that you have to treat the... -
Under the properties of the text box it has scroll bar options. Typically they are system defaults meaning if the text area's data exceeds the visible character limit it will automatically create a scroll bar for you.Leave a comment:
-
How would that work on a horizontal process. I thought about using continuous form. But that only applies vertically and doesn't provide the aesthetic view that i am looking.Leave a comment:
-
Thanks for the response. I have not issues with the properties of the arrows, I am very well versed in that. My concern is the number of tasks. I may have one process with 12 tasks (require 12 arrows) versus another process where I have 5 tasks. My question is how to dynamically create Tasks (Arrows) based on the different processes? Does that makes sense.Leave a comment:
No activity results to display
Leave a comment: