Search results for query: *

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 =...

Hmm! Sorry for my crapass description.. :( The file im about to work with has comboboxes inside cells in one column. It's also a data list so you always have the availablity to sort it. I really dont think the comboxes are Are these comboboxes... 1) Data/Validation 2) ActiveX 3) MS Forms I...

Hi! I have a an excel 2003 woorkbook with some sheets. In one of the sheets one of the columns consists of comboboxes with 4 different values. I have a userform where i look up the correct row, and then add the same text as in the comboxbox. But somehow it does not count as if i had choosen the...

Ahh thanks guys :) Cool I ended up doing the: Stext = Stext & strTextLine & vbCrLf solution... Really good to get to know the readall thing to! BIG ups! To PHV, combo, Andrzejek!!

Hi! Im using excel 2003. I do NOT have acess to the rich textbox ;(, and I can't add it to our system because of security measures. So I use a textbox to get save data to textfiles, works nice! The data in the textbox often contains multiple rows. Example: Hi! We are informing you of...

Hello! Im trying to use Xpath to do collect some data from a page i save, RESULTS ON THE PAGE DIFFER. I save everything(the html source) into my "C" Variable. Thing is that, I can parse that like a LOOONGGG string(I do it with the mid() function and some ohter), but now I want to use the more...