Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. tedb13

    Can anyone explain how text gets smaller and smaller each time you toggle through a texbox?

    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...
  2. tedb13

    Can anyone explain how text gets smaller and smaller each time you toggle through a texbox?

    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...
  3. tedb13

    Is it possible to move data to clipboard once it has been obtained then manipulated using GetString?

    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...
  4. tedb13

    Is it possible to move data to clipboard once it has been obtained then manipulated using GetString?

    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...
  5. tedb13

    Is it possible to move data to clipboard once it has been obtained then manipulated using GetString?

    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...
  6. tedb13

    DLQ question

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

    DropListBox option comes up as numeric value instead of String

    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)
  8. tedb13

    DropListBox option comes up as numeric value instead of String

    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"...
  9. tedb13

    DropListBox option comes up as numeric value instead of String

    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...
  10. tedb13

    ..Get Excel to Extra! Droplist options. Why is this code not working?

    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...
  11. tedb13

    ..Get Excel to Extra! Droplist options. Why is this code not working?

    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...
  12. tedb13

    ..Get Excel to Extra! Droplist options. Why is this code not working?

    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...
  13. tedb13

    ..Get Excel to Extra! Droplist options. Why is this code not working?

    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...
  14. tedb13

    ..Get Excel to Extra! Droplist options. Why is this code not working?

    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...
  15. tedb13

    ..Get Excel to Extra! Droplist options. Why is this code not working?

    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...
  16. tedb13

    ..Get Excel to Extra! Droplist options. Why is this code not working?

    Please refer to thread99-1635974 if you wish to respond, as it is the original request, though some variables have changed. Thank you
  17. tedb13

    Excel Get A if B And C ...Loop

    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)
  18. tedb13

    ..Get Excel to Extra! Droplist options. Why is this code not working?

    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)
  19. tedb13

    ..Get Excel to Extra! Droplist options. Why is this code not working?

    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...
  20. tedb13

    I need to set this macro to run in a loop.

    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)

Part and Inventory Search

Back
Top