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!

Register Log in
  • Congratulations derfloh 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. dixiematic

    There is or there are

    Thank you, gentlemen, for your answers. I was using the wrong form 50 years simply by an analogy to the cases like a heap of tyres WAS there... a collection of objects IS an object... a series (!) of data IS stacionary... a group of students WAS approaching.... a sequence of events WAS...
  2. dixiematic

    There is or there are

    What is correct: 1. There is a lot of musicians... or 2.There are a lot of musicians.... I would appreciate the explanation. I am not a native english speaker. Regards Dixiematic
  3. dixiematic

    Through the window OR out of the window

    Hello 2ffat, mintjulep and CajunCenturion, thank you very much for your precise answers, gentlemen. Special thanks to CC-I really enjoy your explanation! It is not a matter of getting a good grade at school-when you are over 60 and retired it really does not count. Neither is it the point to...
  4. dixiematic

    Through the window OR out of the window

    Hello, friends my wife is studying English for her third university lifetime and she came across a problem. Her teacher says that there are only two cases , firstly "to look out of the window" when somebody looks from inside towards outside and secondly, "through the window", when somebody...
  5. dixiematic

    Food Songs

    A small supplement to Santa Mufasa's list: Ice cream by King, Moll and Johnson Cornbread,Peas and Black Molase by C.Barber(?) A cup of coffee by Caty Perry Coffee and Acker Cake by Acker Bilk(?) Tea for two by V. Youman Whiskey Man Blues by Scrapper Blackwell Yes, we have no bananas by...
  6. dixiematic

    Name for the area under a curve.

    Welshbird, perhaps you can call it "The Marianos area". It sounds very specific. Dixiematic
  7. dixiematic

    Comma Costs Millions

    Did not Pithia in ancient Greece answered to a warriour, who came and asked her to foresee the result of a battle, something like "You die not (you) win". So the foreseen result was entirely comma dependant. m777182
  8. dixiematic

    What to do with the commas here?

    To CajunCenturion It is Slovenian.Quite archaic.In a dictionary I found words similar to sanskrt. I do not have an explanation. In schools we were tought that our ancestors came from behind the Karpati mountains. The DNK maps show similarity to the Baskian people and of couse to Slovakians...
  9. dixiematic

    What to do with the commas here?

    Hi, CajunCenturion Thanks for your answer-I enjoy it, but later my wife gave me a lesson that I obviously deserved because of my poor knowlidge of my own language. It seems that things are more complex here and let me allow to explain it: the kernel of a clause in my language is always a verb...
  10. dixiematic

    What to do with the commas here?

    Hi, The use of commas in English language has always intrigued me and I enjoy a very precise explanation of CajunCenturion although I am not able to make an explanation on the same level with the correct terminology. In his last explanation of the expression "I can write what I want, but feel I...
  11. dixiematic

    Great Mixed Metaphors

    Hi, as a member of amateur musicians community I like the saying " It is nice to play at a funeral if it is not of your own". This one makes my wife mad: "Do not lay down on tomorrow what you can do a day after tomorrow ". A German friend instructed me "Fire in your fingers, ashes in your...
  12. dixiematic

    indirect adressing a TextBox on a sheet

    ...all other objects on a Sheet(even the number of comments- I did not know that comments are objects too) + the members of only the 1st row of an m*n array of TBs that I generate in a loop, but it really does not matter now because I do not want to count the TBs but rather write a text into...
  13. dixiematic

    indirect adressing a TextBox on a sheet

    To SkipVought Thank you for your answer. I have done something similar, but in your code and in mine code the statement If sp.OLEFormat.progID = "Forms.TextBox.1" rises error 438. Additionaly, the statement (in my code) i=ws("sheet2").TextBoxes.count actually counts the number of TBs...
  14. dixiematic

    indirect adressing a TextBox on a sheet

    To SkipVought Thank you that you keep answering me. I think I localised the problem but I do not know the solution. Let me repeat: On Sheet1 I generate i-TextBoxes (by Excel commands) and on Sheet2 j-TextBoxes the same way. Now from the Vba code under Sheet1 additional k-TBs are generated...
  15. dixiematic

    indirect adressing a TextBox on a sheet

    To SkipVought I have to correct my statement: your solution works fine in a short demo as follows. The statement after Line_10 finds all TextBoxes and fills them with some value. The very same statement somewhere else in my program (with another worksheet) stops with error 438. Few days I was...
  16. dixiematic

    indirect adressing a TextBox on a sheet

    To SkipVougth I am sorry, I was already by my granddaughter in my mind. It was error 438 like in a short test code on a newly opened worksheet, where I inserted 6 TextBoxes there. I present the code here : label_10 is passed OK, label_20 does not work. If I skip to label_30 it is again OK. So...
  17. dixiematic

    indirect adressing a TextBox on a sheet

    To SkipVought Thanks, the code as such does not work, perhaps I should trim it a bit... I'll investigate chances with ObjPtr(MyObject) though I have not got the slightest idea how to go further. Will continue on Monday. m777182
  18. dixiematic

    indirect adressing a TextBox on a sheet

    ...= 372 Mytop = 48 MyWidth = 60 MyGap = 2 Myleft = MypositionLeft - MyWidth Worksheets("vesa").Activate For i = 1 To 4 Mytop = 48 + (i - 1) * 19.9 For j = 1 To n Myleft = MypositionLeft + MyWidth * (j - 1) + MyGap Worksheets("vesa").OLEObjects.Add...
  19. dixiematic

    indirect adressing a TextBox on a sheet

    to TonyJollans thanks for your help but sheet_ref.TextBoxes(p) or sheet_ref.TextBoxes.item(p)does not work:RUN TIME ERROR 438. M777182
  20. dixiematic

    indirect adressing a TextBox on a sheet

    I have i-textboxes on a worksheet. By some procedure I calculate a pointer p, 0< p <=i. Now I would like to change the text of the TextBox(p). How could I adress it? m777182

Part and Inventory Search

Back
Top