unfortunately this is not a userform or I would have done just that. I am using activex control textbox. I need to code the tab order. Even if I could set the Tab order, the problem in my querry is the shrinking of the text each time I toggle through them. Thanks all the same.
It's always...
I would also like to know if there is anyone out there who knows how to toggle through the textboxes using Tab and Shift+Tab.
Private Sub TextBox1_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
'If KeyCode = vbKeyTab Then TextBox2.Activate
If KeyCode = vbKeyUp...
Skip. Forgive my poor use of programming jargon. You're right, the GetString function is used to assign a value to a variable, as in my example it assigns the string value "(987)654-3210" to the variable String. Unfortunately, I no longer have access to Extra Basic Help as we've upgraded to...
Hi Skip. I didn't mean to be vague. I am using "String=MyTerminal.GetString(12,26,12)" to copy a few items. For example, a ph# (987)654-3210. I then remove all the non-numeric characters; It is my hope that there is a way to put the data to the clipboard so that when I do the Ctrl-v it pastes it...
Hi, I need to take data I have retrieved then manipulated using the GetString function and enter it into Clipboard to be manually pasted afterwards without using a text file. Does anyone know if this is possible?
It's always better to ask stupid questions; stupid questions have been known to...
Hi Zach,
I am sure that we are not the only ones to ask this question, and read high and low through the Extra! help files in order to find an answer. From my reading, as I am sure you've read too, there is no such functionality. It is only possible when using the "Input" function. Too bad you...
dropcombobox did the trick. Thank you Zak! What's the difference between the two?
It's always better to ask stupid questions; stupid questions have been known to reduce the frequency of stupid mistakes. :o)
I'm sorry, I don't follow. Where would the list find the String? HOTD is a string, with several strings within it. I've tried using an array but got the same result.
HOTD(0)=" "
HOTD(1)="08:00"
HOTD(2)="09:00"
HOTD(3)="10:00"
HOTD(4)="11:00"
HOTD(5)="12:00"
HOTD(6)="13:00"
HOTD(7)="14:00"...
Can anyone explain why the selected string from a list is displayed as the number for which the string is found in the list? example: user selects "09:00", the value returned is 2, where "08:00" is at 0 in the list. I tried using real time values with a For/Next loop n an array, and it displayed...
I believe I may have figured it out, finally. I kept thinking I had to have two separate variables and comparing them. This is what kept giving me errors. This code is not yet tested, and is so simplified. I think it will actually work.
Dim Fruit() As String
...
...
P=1
i=3
Cnt=3
Redim...
Hi, Skip. I will attempt to answer all of your questions without being too wordy, or too vague.
I'm quite excited to learn about what I can do in excel. I even have a few books on excel that I am eager to delve into once I can get all the EB macros updated. In the mean time, there isn't much...
Sorry Skip, I must have misread your post last night. I was half asleep coming off of an extra long shift. The list is in one column and an alternate list is in another column. A1 and C1. The fist list in A1, "to use my example code above", would contain an ordered list of fruits. Some of the...
I did not know that I require code in excel VBA, as well as in EB. This will require a huge learning curve. So far, I have been able to retrieve data from a closed workbook. The problem has been getting StringData(x) to be interpreted as StringData(1), StringData(2), ...,StringData(10) etc...
Is this wrong then?
set objWorkbook=obj.Worksheets("Sheet2")
Thank you for this tidbit. I will have to rethink my logic, and try to resolve my problem with this in mind.
Based on my experience so far, I will agree with that. As I mentioned before though, not everyone has excel open at any...
Thank you again, Skip. I will take it under advisement, and add this new "What not to do:" to my Forum etiquette. I'm not one to walk on others' flower beds. I have a great deal of respect for those who derive personal satisfaction with helping others; it is those individuals that make Forums...
New thread thread99-1638197 started in error. Please refer to it only to obtain more details provided for this request. Thank you.
It's always better to ask stupid questions; stupid questions have been known to reduce the frequency of stupid mistakes. :o)
Thanks for you speedy response Skip. I am unsure of the meaning of your statement, though. Is it with respect to the fact that I started a new thread?
It's always better to ask stupid questions; stupid questions have been known to reduce the frequency of stupid mistakes. :o)
I know that I have approached you with this question before. This code I am presenting reflects my continued efforts to find a solution to my original query. Is there an answer to be given? Is there a solution? It eludes me. Any further pointers would be appreciated. Thank you.
Dim Name1() As...
This one too may be helpful, as well.
thread1-1552700
It's always better to ask stupid questions; stupid questions have been known to reduce the frequency of stupid mistakes. :o)
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.