Hello,.
I got these codes :
=MT4|BID!EURUSDm
=MT4|ASK!EURUSDm
which i would use on a Sheet to get real time price data in a cell.
I want to create a sort of floating userform for my spreadsheet which constantly shows these 2 prices changing but i dont know how to incorporate this formula in VB? Please can someone help?
Also - if i use 2 listboxes on the form to house these 2 bits of data - i would use the following under Userform Initialize
with listbox1
additem (etc).value ***i think***
However - what if i wanted to fill a textbox instead? What would the code be? I tried changing listbox1 to textbox1 but this didn't seem to work.
Thanks in advance.
I got these codes :
=MT4|BID!EURUSDm
=MT4|ASK!EURUSDm
which i would use on a Sheet to get real time price data in a cell.
I want to create a sort of floating userform for my spreadsheet which constantly shows these 2 prices changing but i dont know how to incorporate this formula in VB? Please can someone help?
Also - if i use 2 listboxes on the form to house these 2 bits of data - i would use the following under Userform Initialize
with listbox1
additem (etc).value ***i think***
However - what if i wanted to fill a textbox instead? What would the code be? I tried changing listbox1 to textbox1 but this didn't seem to work.
Thanks in advance.