Hacker News Reader

For example.. `Dim x, y as Long` results in only `y` being long. Internal functions like `InputBox` or string functions like `Left`,` Right`, `Trim`, `Mid`, and so on return variant not string. So you have to do a little extra there.

View on HN

You can append a "$" to those functions (ie, Left$(), Right$(), Mid$(), etc) to use the "return a string" version of these functions.

Yes, and that's why I mention those specific functions.

Reply on news.ycombinator.com