-
WSgchutrau
AskWoody Loungerit seems that this does this does the trick:
Private Sub x_spacing_Change() ‘ x_spacing is the textbox
Dim userinput As Integer
userinput = x_spacing.Value
Sheets(“hidden_data”).Range(“xspace”).Value = userinput
End SubBut I am surprised that although having and advanced user interface like the properties window for the textbox, that it slipped from the developers, that textbox user input could be formatted there as an option! Recognizing user input as text , numbers, etc and sending with that format to the linked cell should be straight forward and automatic.
Thank you
-
WSgchutrau
AskWoody Loungerit seems that this does this does the trick:
Private Sub x_spacing_Change() ‘ x_spacing is the textbox
Dim userinput As Integer
userinput = x_spacing.Value
Sheets(“hidden_data”).Range(“xspace”).Value = userinput
End SubBut I am surprised that although having and advanced user interface like the properties window for the textbox, that it slipped from the developers, that textbox user input could be formatted there as an option! Recognizing user input as text , numbers, etc and sending with that format to the linked cell should be straight forward and automatic.
Thank you
-
WSgchutrau
AskWoody LoungerUser input in a textbox (inserted from the Control Toolbox and linked a spreadsheet cell) always defaults to text?
There is no way to overide that? Not even with code?
-
WSgchutrau
AskWoody LoungerUser input in a textbox (inserted from the Control Toolbox and linked a spreadsheet cell) always defaults to text?
There is no way to overide that? Not even with code?
-
WSgchutrau
AskWoody LoungerThat would work.
But,,,, problem: I have several formulas that refer to A1. And replacing A1 in the formulas , for Value(A1), would add a lot of text in my formulas and make syntax difficult to understand. (I have several cells that are linked to several textboxes. These cells provide numeric data to the formulas)
Is there a way I can format the text box so the cell receives the numbers that the user is typing , already as numeric data, so I dont have to edit the formulas?
Thank you
-
WSgchutrau
AskWoody LoungerThat would work.
But,,,, problem: I have several formulas that refer to A1. And replacing A1 in the formulas , for Value(A1), would add a lot of text in my formulas and make syntax difficult to understand. (I have several cells that are linked to several textboxes. These cells provide numeric data to the formulas)
Is there a way I can format the text box so the cell receives the numbers that the user is typing , already as numeric data, so I dont have to edit the formulas?
Thank you
-
WSgchutrau
AskWoody LoungerSeptember 16, 2003 at 4:18 pm in reply to: Make table query expression – following record (2002) #715551I have an Excel spreadsheet to load gridded data from a map (a point set), and trim down a certain number of “nodes” based on spacing in X and Y.
My data comes from an ASCII file consisting of 3 columns : X coordinate , Y coordinate and altitude.
But excel is limited by the amount of rows you can load, so I guessed that the same task could be done with Access.
I linked the ASCII file to a table. I have a query to extract the max and min X and Y. I have another “make table query” with an expression that will yield true or false if X or y are multiples of a “spacing” that I supply to trim down the data. This make table query uses as input for the expression, the fields in the first query.
In that way I can trim my data to keep only for example, a 10 * 10 X-Y spaced grid.
But I also want to keep the node data that belongs to the end of each rib of the new grid (imagine mapping an ice cap; I want to keep the data corresponding to the end of each data line in X and Y, where the ice cap actually ends). In Excel, my data is sorted by X and Y, and I have a formula that checks the value of X (or Y) in each row, and the value of X immediately above. If it is not the same, it flags the row, sow I can eventually keep that row in my final listing, with the autofilters.
I thought that with Access, I could query a sorted table, and have an expression that would mimic the formula I have in Excell to flag the records where my X (or Y) value changes in the sorted list.
Excel works fine with small datasets, but ASCII with 100,000 lines (real life) are dificult to handle
Comments, suggestions? Thank you
-
WSgchutrau
AskWoody LoungerSeptember 16, 2003 at 4:18 pm in reply to: Make table query expression – following record (2002) #715550I have an Excel spreadsheet to load gridded data from a map (a point set), and trim down a certain number of “nodes” based on spacing in X and Y.
My data comes from an ASCII file consisting of 3 columns : X coordinate , Y coordinate and altitude.
But excel is limited by the amount of rows you can load, so I guessed that the same task could be done with Access.
I linked the ASCII file to a table. I have a query to extract the max and min X and Y. I have another “make table query” with an expression that will yield true or false if X or y are multiples of a “spacing” that I supply to trim down the data. This make table query uses as input for the expression, the fields in the first query.
In that way I can trim my data to keep only for example, a 10 * 10 X-Y spaced grid.
But I also want to keep the node data that belongs to the end of each rib of the new grid (imagine mapping an ice cap; I want to keep the data corresponding to the end of each data line in X and Y, where the ice cap actually ends). In Excel, my data is sorted by X and Y, and I have a formula that checks the value of X (or Y) in each row, and the value of X immediately above. If it is not the same, it flags the row, sow I can eventually keep that row in my final listing, with the autofilters.
I thought that with Access, I could query a sorted table, and have an expression that would mimic the formula I have in Excell to flag the records where my X (or Y) value changes in the sorted list.
Excel works fine with small datasets, but ASCII with 100,000 lines (real life) are dificult to handle
Comments, suggestions? Thank you
-
WSgchutrau
AskWoody Lounger(Edited by WendellB on 15-Sep-03 12:55. activate hyperlink)
I didn’t try the last trick , but http://www.soniacoleman.com/Tutorials/Powe…quicktricks.htm%5B/url%5D is an excellent link.
There is a trick there that can do the job too, without the animations (that gets very tedious , if I have a large set of text help boxes).
The trick involves creating a bookmark to the same slide and use the bookmark text help tips to display the additional text!
Thank you very much
-
WSgchutrau
AskWoody Lounger(Edited by WendellB on 15-Sep-03 12:55. activate hyperlink)
I didn’t try the last trick , but http://www.soniacoleman.com/Tutorials/Powe…quicktricks.htm%5B/url%5D is an excellent link.
There is a trick there that can do the job too, without the animations (that gets very tedious , if I have a large set of text help boxes).
The trick involves creating a bookmark to the same slide and use the bookmark text help tips to display the additional text!
Thank you very much
-
WSgchutrau
AskWoody LoungerIt will not underline an URL interactively if I type it.
But if I insert a link or bookmark , it will underline it and turn to the color scheme color assigned to hyperlinks
Thanks
-
WSgchutrau
AskWoody LoungerIt will not underline an URL interactively if I type it.
But if I insert a link or bookmark , it will underline it and turn to the color scheme color assigned to hyperlinks
Thanks
-
WSgchutrau
AskWoody Loungersort of…
the alternatives are:
1. have just one word or letter (or special additional character) carrying the link
2. insert an object (visible or not) with the attached link or bookmarkgood! Thank you
-
WSgchutrau
AskWoody Loungersort of…
the alternatives are:
1. have just one word or letter (or special additional character) carrying the link
2. insert an object (visible or not) with the attached link or bookmarkgood! Thank you
-
WSgchutrau
AskWoody LoungerIt didn’t work.
thanks anyway
![]() |
Patch reliability is unclear. Unless you have an immediate, pressing need to install a specific patch, don't do it. |
SIGN IN | Not a member? | REGISTER | PLUS MEMBERSHIP |

Plus Membership
Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.
AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.
Get Plus!
Welcome to our unique respite from the madness.
It's easy to post questions about Windows 11, Windows 10, Win8.1, Win7, Surface, Office, or browse through our Forums. Post anonymously or register for greater privileges. Keep it civil, please: Decorous Lounge rules strictly enforced. Questions? Contact Customer Support.
Search Newsletters
Search Forums
View the Forum
Search for Topics
Recent Topics
-
Windows 7 ISO /Windows 10 ISO
by
ECWS
58 minutes ago -
No HP software folders
by
fpefpe
1 hour, 42 minutes ago -
Which antivirus apps and VPNs are the most secure in 2025?
by
B. Livingston
1 hour, 6 minutes ago -
Stay connected anywhere
by
Peter Deegan
7 hours, 5 minutes ago -
Copilot, under the table
by
Will Fastie
4 hours, 19 minutes ago -
The Windows experience
by
Will Fastie
13 hours, 19 minutes ago -
A tale of two operating systems
by
Susan Bradley
4 hours, 15 minutes ago -
Microsoft : Resolving Blue Screen errors in Windows
by
Alex5723
18 hours, 39 minutes ago -
Where’s the cache today?
by
Up2you2
1 day, 9 hours ago -
Ascension says recent data breach affects over 430,000 patients
by
Nibbled To Death By Ducks
1 day, 2 hours ago -
Nintendo Switch 2 has a remote killing switch
by
Alex5723
3 hours, 5 minutes ago -
Blocking Search (on task bar) from going to web
by
HenryW
1 day, 10 hours ago -
Windows 10: Microsoft 365 Apps will be supported up to Oct. 10 2028
by
Alex5723
2 days, 3 hours ago -
Add or Remove “Ask Copilot” Context Menu in Windows 11 and 10
by
Alex5723
2 days, 3 hours ago -
regarding april update and may update
by
heybengbeng
2 days, 4 hours ago -
MS Passkey
by
pmruzicka
1 day, 6 hours ago -
Can’t make Opera my default browser
by
bmeacham
2 days, 12 hours ago -
*Some settings are managed by your organization
by
rlowe44
1 day, 23 hours ago -
Formatting of “Forward”ed e-mails
by
Scott Mills
2 days, 11 hours ago -
SmartSwitch PC Updates will only be supported through the MS Store Going Forward
by
PL1
3 days, 7 hours ago -
CISA warns of hackers targeting critical oil infrastructure
by
Nibbled To Death By Ducks
3 days, 16 hours ago -
AI slop
by
Susan Bradley
1 day, 10 hours ago -
Chrome : Using AI with Enhanced Protection mode
by
Alex5723
3 days, 17 hours ago -
Two blank icons
by
CR2
1 day, 1 hour ago -
Documents, Pictures, Desktop on OneDrive in Windows 11
by
ThePhoenix
1 day, 3 hours ago -
End of 10
by
Alex5723
4 days, 4 hours ago -
Single account cannot access printer’s automatic duplex functionality
by
Bruce
3 days, 2 hours ago -
test post
by
gtd12345
4 days, 10 hours ago -
Privacy and the Real ID
by
Susan Bradley
4 days, 1 hour ago -
MS-DEFCON 2: Deferring that upgrade
by
Susan Bradley
2 days, 3 hours ago
Recent blog posts
Key Links
Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.
Mastodon profile for DefConPatch
Mastodon profile for AskWoody
Home • About • FAQ • Posts & Privacy • Forums • My Account
Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts
Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.