Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

To SkipVought I found a solution to how to address (p-k)TextBoxes generated by code: I have to address them by name For i=k to p MyTextBoxName="TextBox" & i Worksheets("Mysheet").OLEObjects(MyTextBoxName).Object.Text="bla bla.." Still I do not know why I cannot count my TextBoxes correctly-...

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

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

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

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

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

TO GlennUK this is a part of the code: I create an array (4 x j)of TextBoxes adjacent to the already created boxes (6) and then I would like to fill them with the values of an array of variables x(i). Neither of labels 100, 200 or 300 work. Label_create_Textboxes: MypositionLeft = 372 Mytop =...

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

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