Recent content by kalle82

Hi! Just as the subject tells you. How do I use another delimiter than comma, I want to use the pipe "|". Input #1, date1, loggen, date2 'address2, lngItemIndex = lngItemIndex + 1 Set lvItems = UserForm1.Controls(dynamicbox).ListItems.Add lvItems.Text = date1...

Hi! I have had this problem a couple of times and managed to solve it by some tedious work. Now it's gotten really complicated... Our IT -department, controls all installations and updates and we are currently running excel 2003. We are supposed to have the same installations and everything...

Hmm! When I run it give me "" for the nytext vairable here how i Call it nytext = regexsolution(nytext) and the function NOW looks like this Public Function regexsolution(mystring As String) As String 'Dim mystring As String Dim m As Variant Dim nytest As String tempString = mystring...

Hi! I have gotten so much help here! And I have come a long way programming VBA with all the help I get! Now, in a thread from yesterday I learned a really nice way of using regex. I put that piece of code in a function in MODULE 1. Public Function regexsolution(mystring As String) 'Dim...

Hi! I have a textbox consisting of a lot of text both numbers and chars. Now in order to make the text dynamic i use replace on the text with certain variables, for example: If the user needs the date 14 from now. I let him/her write #date14# and the program then searches the textbox for this...

Hey! It does not work with If ListView2.SelectedItem.Index < 0 Then Cause the objectvariable or with variable has not been set(freely translated from swedish) If ListView21.SelectedItem Is Nothing Then does not work since it returns "" and that is not the same as nothing i presume.. ...

Hi! I have a lsitbox which in turn stores logs. These logs can be added, amended and deleted. Works like a charm. But sometimes my users want to delete the logs and they click one time to many... Which in turn results in that there is no selecteditem, and hence no index which give me an error...

Thanks COMBO! Worked like a charm! I thee a manual of some sorts to be able to control the api? Cheers!

Hi! How do i even do to change the alt tab icon? Im using excel 2003. I have looked into the matter but it's way beyond me using those api's... I have added code to get a minimize button and added the userform to the windows taskbar. This was done with code I found on the net.. But I can't...

There is something(probably) a count function in the file that is supposed to count the rows that has a value. When using My macro to add those recirds does not show up when it counts the rows which has a value. Sorry for being so vague I'm not the creator of the file... Only thing i know is...

No its works! But as you stated before, it breaks the data validation...

strRowNoList is the row where the identifier has been found, this for loop iterates throug all cells in B column, and stops when intMystring has been found. strRowNoList = strRowNoList & cell.Row intMyString = identifier 'Value to search for, change as required. lngLastRow = Cells(Rows.Count...

Hi! The code that puts the value in the combobox is as follows Sheets("Ärenden").Range("K" & strRowNoList).Value = logtext The logtext variable consists Of the following: Logtext = combobox1.value

I have a combobox with four values on my userform. I WANT IT TO DO THE FOLLOWING When a user clicks on a commandbutton. It should take the value from the userform combobox, enter this into the datavalidation combobox inside the workbook. I have alreday accomplished all this. But with my...

Hi, this is the code I'm using! It's the logtext that fails the validation. is there a way you can tell it to set the combobox.index(4), so that the validation does not break? Sub avslutaarende(pages, thedate) Select Case pages Case Is = 1 identifier = UserForm1.TextBox10.Text logtext =...